I am trying to re-work the attached sheet. I am wanting the distribution chart as a pivot chart. The chart is designed to show the percentage of outlets that stock the relevant products (by showing which have bought the products in the last 12 months) Currently, users will filter on the Group, Custom Group, or Rep Ownership column(s) in the Detail tab, which will then update the values in row 105 which feed into the graph (the real data has over 5000 lines). I want to put in slicers for Group, Custom Group and Rep Ownership so users do not need to leave the graph page to make filter selections. My pivot table skills are limited and I'm hoping the experts here can point me in the right direction.
Thanks in advance.
Bookmarks