Hope I can explain this so it makes sense. I'll simplify to hopefully accomplish this. I have a table with columns of Monthyr, Store, Manager, Item, Cost.
This data is displayed in a Pivot Chart with MonthYear on the X Axis, Cost on the Y.
I have a "Store" Slicer with 10 Stores.
I would like to show another slicer of "Manager" (2 managers), but each manager oversees overlapping stores. For example, Manager 1 oversees Store 1, 3, 5, 7, 10. Manager 2 oversees Store 2, 3, 6, and 9, and 10.
I'd like to add Slicer to list the the two managers and when I select Manager 1 it will display data from their corresponding stores, even though store 3 overlaps. How do I add this manager "grouping" to this data model? Thanks for any help.
This data is displayed in a Pivot Chart with MonthYear on the X Axis, Cost on the Y.
I have a "Store" Slicer with 10 Stores.
I would like to show another slicer of "Manager" (2 managers), but each manager oversees overlapping stores. For example, Manager 1 oversees Store 1, 3, 5, 7, 10. Manager 2 oversees Store 2, 3, 6, and 9, and 10.
I'd like to add Slicer to list the the two managers and when I select Manager 1 it will display data from their corresponding stores, even though store 3 overlaps. How do I add this manager "grouping" to this data model? Thanks for any help.
