I'm having some trouble using the Sort By Expression feature in my Pivot Table. The requirement is to sort in descending order by the values in the last expression within each first dimension group. I have tried several approaches, and the one that seems to come closest is to use AGGR to get an equivalent of the last expression (see attached) and apply that on the last dimension. This works fine as long as i filter to just one report month. But when i clear the filter to see all reports, or select more than one report month, the sorting changes.