Dear Experts: I placed two pivot table reports one next to the other on a worksheet. Both share the same datasource.
The left pivot table (MyPT-01) has been sorted by Sales 2021 descending. The corresponding countries are now in some specific order.
I would like to sort the countries of the other pivot table (MyPT-02) to match the sorting of the countries of the left Pivot Table (MyPT-01)
I am pretty sure this can only be achieved by means of a macro.
Help is much appreciated, Thank you very much in advance.
I have attached the pivot table file for your convenience.
sorting-based-on-another-sorting-range-pivot-vba.xlsx
Alternatively, how about using a table of SUMIFS formulas alongside the first pivot to get the breakdown data that shows in the second pivot, using the country column from first pivot as one of the criteria.