Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Part | Load Date | Segment | Totals |
---|---|---|---|
123456-123 | 5/29/2017 | Total Forecast | 2800 |
123456-123 | 5/29/2017 | Shipment | 500 |
123456-123 | 5/29/2017 | Open Order | 100 |
123456-123 | 6/29/2017 | Total Forecast | 5000 |
123456-123 | 6/29/2017 | Shipment | 350 |
123456-123 | 6/29/2017 | Open Order | 224 |
All,
I have learned a lot from reading the forums and finally decided to post after struggling to figure out what would allow me to do the following. I am not working on anything specific but for my own self paced learning and wanted to understand how something could be done. In the example above I have multiple columns, one of which is segment. In segment for each part the 3 key values are always populated (Total Forecast, Shipments, Open Orders). What I am looking to do is have a KPI that shows only the total forecast when a particular part and load date are selected. I know I am missing something simple. I have several KPI's from other sources that I have working, however, they do not require a field filter to only look at one component.
The result I am looking for would be the KPI box and say I selected in my filter pane's the part and load date of 6/29, I would expect the KPI result to show 5000, if I unselected the data it would show the combined 7800.
I hope this makes sense.
Thanks
Houston
may be this exp in text box
Sum({<Segment={"Total Forecast"}>}Totals)
Thanks Aar for the quick response!