ExcelBanter - Sort Pivot Table

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

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

- - Sort Pivot Table (https://www.excelbanter.com/excel-discussion-misc-queries/166368-sort-pivot-table.html)

juanpablo

Sort Pivot Table

How do I sort the results of a Pivot Table in descendant order?

JPG

Jim Thomlinson

Sort Pivot Table

Select the field you want sorted (row or column) and right click. Select
Field Settings|Advanced. Sorting is in the bottom left hand corner of the
dialog box...
--
HTH...

Jim Thomlinson

"juanpablo" wrote:

How do I sort the results of a Pivot Table in descendant order?

JPG

All times are GMT +1. The time now is 12:01 PM.