October 11, 2021
I have created a dashboard which includes the sparklines to show trends between branches but when I change the slicers all the pivot tables in my "Sparklines Pivot" tab change to the same branch instead of being separated.
This screenshot below was "ALL" at the top and then the next one should show 56 but they all have changed to branch 56 (total of 8 branches/ pivot tables).
Is this something easily fixed? My excel file is a little too big to upload. Thanks for taking a look!
February 13, 2021