Create the main dashboard from the Part Plant (or Warehouse I can't
remember off the top of my head)
Publish the company and part num
Add at tracker view using the shipment details filtered on Company and
Partnum
Add a filter to get only those shipments from the last 12 months
Set it to group and summarize the shipments by Year/Month (The shippers
do not contain fiscal information)
Or create a query that summarizes the shipments and display that in the
sub tracker.
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of thedemondamian
Sent: Friday, October 23, 2009 11:58 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Parts On Hand + Total Sales Dashboard/Tracker
I need a dashboard that will show me the OnHandQTY, Total Demand, and
the last 12 months Total Shipped Qty per Fiscal Period (by part).
For example; one line of the grid would look like this:
Part | OnHandQTY | Demand | Fiscal 1 | Fical 2 | Fiscal 3...
I do not believe that this can be done through a standard BAQ.
The only way I can see to do it is to create a dashboard, add a tracker
view, throw a grid on it, gather the data and manipulate it in the
script editor. Then throw it in the grid.
Any Ideas!?!
[Non-text portions of this message have been removed]
remember off the top of my head)
Publish the company and part num
Add at tracker view using the shipment details filtered on Company and
Partnum
Add a filter to get only those shipments from the last 12 months
Set it to group and summarize the shipments by Year/Month (The shippers
do not contain fiscal information)
Or create a query that summarizes the shipments and display that in the
sub tracker.
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of thedemondamian
Sent: Friday, October 23, 2009 11:58 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Parts On Hand + Total Sales Dashboard/Tracker
I need a dashboard that will show me the OnHandQTY, Total Demand, and
the last 12 months Total Shipped Qty per Fiscal Period (by part).
For example; one line of the grid would look like this:
Part | OnHandQTY | Demand | Fiscal 1 | Fical 2 | Fiscal 3...
I do not believe that this can be done through a standard BAQ.
The only way I can see to do it is to create a dashboard, add a tracker
view, throw a grid on it, gather the data and manipulate it in the
script editor. Then throw it in the grid.
Any Ideas!?!
[Non-text portions of this message have been removed]