sort sum column of pivot ??

Question

sort sum column of pivot ??

Anonymous

https://docs.google.com/spreadsheets/d/1GUyTK5iAXHGr30A\_XMZ9m7A2KlSjEYX9/edit?usp=drivesdk&ouid=116089498010699794174&rtpof=true&sd=true

i can't seem to sort the sum of values ....it seems i can only sort according to the other columns in the "rows" field

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

1 answer

Answer 1

You can sort that way, but only within each grouping; the subtotals of that grouping (whether you can see the subtotals or not) are sorted, so you need to do the following for all the fields (columns). [Don't expect the entire table to be sorted by sum of values, that would ungroup the other groupings! The only way to do that is by adding a Net Amount column as the leftmost column of the pivot and sort on that.]:

then:

Share via

sort sum column of pivot ??

1 answer