| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting Pivot Table by Total
Does anyone know if there is a way to use the Grand Total column of a pivot
table to sort data in decending order? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sorting Pivot Table by Total
Right click the Field that you want to sort by so in this case the left most
column. Select Field Settings - Advanced and then sort descending based on that field's sum... -- HTH... Jim Thomlinson "Karin" wrote: Does anyone know if there is a way to use the Grand Total column of a pivot table to sort data in decending order? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Table Row Total | Excel Discussion (Misc queries) | |||
| Showing Pivot Table total on Associated Pivot Chart | Excel Discussion (Misc queries) | |||
| Sorting Pivot Table by Grand Total | Excel Discussion (Misc queries) | |||
| Sorting Pivot Table by Grand Total | Excel Discussion (Misc queries) | |||
| Sub Total In Pivot Table | Excel Discussion (Misc queries) | |||
Linear Mode
