Sorting Pivot Table by Grand Total
 

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


--
Meg W
------------------------------------------------------------------------
Meg W's Profile: http://www.excelforum.com/member.php...o&userid=33475
View this thread: http://www.excelforum.com/showthread...hreadid=532912

Sorting Pivot Table by Grand Total
 

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

Martin


--
mrice


------------------------------------------------------------------------
mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931
View this thread: http://www.excelforum.com/showthread...hreadid=532912