Sorting Pivot Table by Grand Total

M

Meg W

I have a pivot table to sum data (premium). I have two variables in the
columns (company and state) and one variable in the row (class) to show
the grand total of premium by class depending on which company and
state are chosen. I'm having a hard time arranging the data so it is
sorted by size of grand total - every time the table is rearranged, the
grand total column moves and the data must be resorted. Is there a way
to automatically resort the data every time the table is changed?

Any help on this matter would be greatly appreciated!

Thanks,
Meg W
 
M

mrice

You might try a macro linked to the sheet_change event. I can't
immediately see another way of doing it.

Martin
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sorting Pivot Table by Grand Total 2
Pivot table grand total location 1
Pivot Table Calculates the Difference in Grand Total 2
Grand Total for Rows not Working in a Pivot Table 1
Sorting Pivot Table by Total 1
Pivot Table Grand Total 3
Pivot Table (Grand Total) 1
Grand Totals for Pivot Tables 4

Top