Showing results for 
Search instead for 
Did you mean: 

Pivot Table Custom Sort

9 - Travel Pro
9 - Travel Pro

I have a pivot table that lists member names, as well as sales totals. Can I customize the sorting of the table in some way that has the members with the highest overall sales shown in order? The sales are also broken down by category. The only way I can sort right now is by alphabetic order, with sales order by category by member name. I would like to have the table sorted by member name with the total largest sales.


10 - ETL
10 - ETL

@Jack_Machesky A work around would be to use a regular "Table" or a "Table With Aggregation" if you need to use functions. Note, you would lose the grouping but you can sort by any column then.