ExcelBanter - Sorting Pivot Table by Total

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Sorting Pivot Table by Total (https://www.excelbanter.com/excel-discussion-misc-queries/199027-sorting-pivot-table-total.html)

Karin

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?

Jim Thomlinson

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?

All times are GMT +1. The time now is 07:05 AM.