M
Meg W
I have created a pivot table which displays the sum of premiums. I hav
the data divided by two variables (company and state) in the columns an
by one in the row (class) to show the Grand Total of premiums by clas
across which company and state are selected. I am having troubl
sorting the data by size of the grand total of premium instead o
class; every time the pivot table is adjusted to show a differen
number of columns, I must resort the data. Is there a macro that ca
be created or a way of adjusting the table so that the data i
automatically sorted by premium size?
Any help would be greatly appreciated!
Thanks,
Meg
the data divided by two variables (company and state) in the columns an
by one in the row (class) to show the Grand Total of premiums by clas
across which company and state are selected. I am having troubl
sorting the data by size of the grand total of premium instead o
class; every time the pivot table is adjusted to show a differen
number of columns, I must resort the data. Is there a macro that ca
be created or a way of adjusting the table so that the data i
automatically sorted by premium size?
Any help would be greatly appreciated!
Thanks,
Meg