I have got a simple pivot table with sales figures for 2020 and 2021.
I am showing the 2021 values as difference from 2020 values. The pivot table is linked to a bar chart.
I also got a slicer with which I can filter the product categories for the sales figures.
I now would like to get the following achieved.
Whenever the user selects any number of items in the slicer, the Slicer-filtering-automatic-sorting-descending.xlsm
I have attached a sample file for your convenience.
Help is very much appreciated.
Thank you very much in advance.