asked on Custom sort a pivot table based on the specific sorting of another pivot table
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
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
VBAMicrosoft ExcelMicrosoft Office
Last Comment
Ejgil Hedegaard
ASKER
Hi Rob,
thank you very, very much for your swift answer and the suggested approaches.
As a matter of fact I am looking for a VBA solution.
thank you very, very much for your swift answer and the suggested approaches.
As a matter of fact I am looking for a VBA solution.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
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.