Attached is a sample workbook to help get across what I'm trying to do.
I have a data set with sales by month for stores, and each store is part of a district. There is one pivot table for the stores (with a corresponding slicer) and another pivot table for the districts (with a corresponding slicer).
I would like a graph for the sales by month of each store to be visible, but only if one district is selected. For example if multiple districts were selected on the district slicer, then no graphs would be visible. If only district 1 was selected, then graphs for store A and store B would be visible.
I added a graph and it is dynamic with the slicers, but it shows all of the stores on one graph. I need a separate graph for each store.
slicer.JPG
Any input would be greatly appreciated.
Bookmarks