Sorting in pivot tables by totals

Looker Q&A Looker
, ,
1

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.

1 Like
2

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.