Slicers present buttons that you may click on to filter Pivot Desk knowledge, however along with the short filtering, slicers additionally point out the present filtering choice, which makes it simple to know what precisely is proven in a filtered Pivot Desk report.
So this drill down appeared to be all properly and good, with my spreadsheet resolution, however one difficulty that did come up was the variety of clicks it took to ‘Begin Over’ or reset the entire Slicers again to point out the entire knowledge. (There have been fairly just a few slicers on the work sheet- like four). Whether or not that is deemed rather a lot might be a matter of personal opinion… and the way versed you might be in manipulating the work sheet utilizing the Pivot Desk Slicers however the feed again from this viewers was that there have been too many clicking choices.
The problem was that the slicers had been wanted to be there to drill down however took too lengthy to reset.
So, I made a decision to make use of a teeny piece of code to allow one button to reset the entire Slicers with one click on. So right here is the small piece of code for my macro which I then connected to a button on the work sheet.