Pretty new to PowerPivot party, trying to figure out how to do this the best way schematically. Below is an example for simplicity. I want to analyze the number of items by store for each color, and put into a PivotChart by Qtr and Year.
But, I have two managers that look at different combination of stores. Manager 1 looks at Smiths and Cravens. Manager 2 looks at Cravens and Bransons. I'd like to have a Slicer for each Manager's chart where only their stores are indicated when I click on each Manager's slicer. As you can see, the Craven store is shared among the two managers. I probably will have to add more managers as they get hired which also will be analyzing shared stores. Hope this makes sense. Thoughts?
Quarter Year Item Store
1 2013 Red Shoe Smiths
1 2013 Red Shoe Pauls
2 2013 Blue Shoe Smiths
2 2013 Blue Shoe Cravens
2 2013 Purple Shoe Smiths
3 2013 Yellow Shoe Branson
3 2013 Blue Shoe Smiths
3 2013 Red Shoe Cravens
But, I have two managers that look at different combination of stores. Manager 1 looks at Smiths and Cravens. Manager 2 looks at Cravens and Bransons. I'd like to have a Slicer for each Manager's chart where only their stores are indicated when I click on each Manager's slicer. As you can see, the Craven store is shared among the two managers. I probably will have to add more managers as they get hired which also will be analyzing shared stores. Hope this makes sense. Thoughts?
Quarter Year Item Store
1 2013 Red Shoe Smiths
1 2013 Red Shoe Pauls
2 2013 Blue Shoe Smiths
2 2013 Blue Shoe Cravens
2 2013 Purple Shoe Smiths
3 2013 Yellow Shoe Branson
3 2013 Blue Shoe Smiths
3 2013 Red Shoe Cravens