Sorting in pivot tables by totals

[victor_rt88]

Hi

I have a pivot table with two dimension and another one that is pivoted, and I am using only one measure, the thing is that I added total, row total and subtotals. I would like to sort the entire pivot chart by the rightmost column (total) and not by my first dimension that is sorted alphabetically.

[Sharon_Z]

hi @victor_rt88, when subtotals are being used, we do not allow sorting on only the row_totals field because that would break up the dimension grouping for the subtotals. If you uncheck subtotals, it should allow you to sort on that rightmost column.