[Solved] - See post #16
Solution: To sort by value in a tabular pivot table, highlight the first "ROW" field that varies in the group you want to sort by in value and right click to sort by more options. Sort by the sum of the Value field that was originally intended to be sorted ( ASC / DESC ). Tabular pivots with a static leading "ROW" field can be sorted directly by right clicking the corresponding values you want to sort by if there is only 1 additional "ROW" field that varies. Upon the 3rd "ROW" field of varied values the solution in #16 has to be applied
See basic example below,
I made the pivot table in Tabular Form with Repeat All Item Labels
- I removed the subtotals
- How do I sort the sum of VALUE 1?
( Images deleted )
Workbook attached
Bookmarks