ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Pivot table data sorting (https://www.excelbanter.com/excel-discussion-misc-queries/210582-pivot-table-data-sorting.html)

Dil

Pivot table data sorting
 
I'm trying to sort my pivot table by a data field. For example, I have about
5 row fields and 12 sum fields in the data section. I'd like to sort one of
the sum fields from highest to lowest, but the table keeps the data sorted by
the rows. Is there anyway to remove that sort and sort by the data fields
instead?

Thanks!



All times are GMT +1. The time now is 09:21 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com