Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting Pivot Table by Grand Total
I have created a pivot table which displays the sum of premiums. I have the data divided by two variables (company and state) in the columns and by one in the row (class) to show the Grand Total of premiums by class across which company and state are selected. I am having trouble sorting the data by size of the grand total of premium instead of class; every time the pivot table is adjusted to show a different number of columns, I must resort the data. Is there a macro that can be created or a way of adjusting the table so that the data is automatically sorted by premium size? Any help 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=532784 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting Pivot Table by Grand Total
Right-click the Company field button, and choose Field Settings
Click the Advanced button Under AutoSort, select Ascending Under Using Field, choose Sum of Premiums Click OK, click OK Do the same for the State field button. Meg W wrote: I have created a pivot table which displays the sum of premiums. I have the data divided by two variables (company and state) in the columns and by one in the row (class) to show the Grand Total of premiums by class across which company and state are selected. I am having trouble sorting the data by size of the grand total of premium instead of class; every time the pivot table is adjusted to show a different number of columns, I must resort the data. Is there a macro that can be created or a way of adjusting the table so that the data is automatically sorted by premium size? Any help would be greatly appreciated! Thanks, Meg W -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting Pivot Table by Grand Total
Thanks so much! It worked perfectly. 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=532784 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using a Pivot Table Calculated Field to get a Unique Count | Excel Worksheet Functions | |||
Change Data In Pivot Table | New Users to Excel | |||
Pivot Table - Multiple consolidation Range | Excel Worksheet Functions | |||
how to delete/clean out the row list in pivot table | Excel Worksheet Functions | |||
Sorting pivot table drop-down | Excel Discussion (Misc queries) |