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