2 Replies Latest reply: Jan 29, 2016 1:53 PM by Ashley Casselman RSS

    Straight Table Sort on Expression

    Ashley Casselman

      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.

      Can anyone see what i need to do differently?

      Thanks