sort multiple fields in a pivot table at the same time
The issue that consume a lot of time and is highly frustrating is this: We have a pivot table with multiple rows on the rows area, for example, Category | Subcategory| Commodity and then we have the $Sales value in the Value area of the pivot. If we were to Sort in descending order by $Sales all of these row fields, we need to go to each row fields and do it one by one -> Highlight cell, right click, sort descending by $Sales, then again for the next row field (Sub-category) and lastly again for Commodity. If we were to have a simple way to sort all of these columns/fields at one time, then we would be more efficient and would avoid many non-productive repetitions.
Kenneth Barber commented
The sorting of multiple columns is called radix sort. Keep in mind that even if there were some sort of radix sort assistant, you would still need to specify the order in which the columns are sorted.