PBi Report Target Values
I have 3 Locations China Germany and USA
I have 5 Product Lines Product A, Product B, Product C, Product D, Product E
A, B, C Manufactured in China
A, B, D Manufactured in Germany
C, D, E Manufactured in USA
Target Values are different for each Product Line, and Location combination
Here is the part that I am stuck on.
The Total Team in each Location has a goal called "Central" (All Product Lines, but it is not an avg or sum of Target Values)
I can filter for all of the results and display the results from a data input table that I created, but I don't know how to show "Central". How do I associate "Central" as representing all of the Product lines when this option is not in any associated columns.
TLDR: End Goal - Click on a Chiclet Slicer for Location and a separate Chicklet slicer for Product Line, and receieve the target Value in a "Card" visualization. The Same filters will filter other tables based on the same attributes, but do not know what to do with "Central".
Thank you.
