Avatar of Andreas Hermle
Andreas Hermle
Flag for Germany

asked on 

automatically sort pivot table in descending order on data slicer changes

Dear Experts:

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.

Regards, Andreas

VBAMicrosoft ExcelMicrosoft Office

Avatar of undefined
Last Comment

8/22/2022 - Mon