Sum totals where field = 'x'

[Anonymous]

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

[aarkay29 · Accepted solution]

may be this exp in text box

Sum({<Segment={"Total Forecast"}>}Totals)

[Anonymous]

Thanks Aar for the quick response!