8 Replies Latest reply on Jul 25, 2016 8:33 PM by Emily Z

    How to sort when there're two dimensions while keeping the display hierarchy?

    Emily Z

      Hi,

       

      I have a problem regarding sorting. What I want is to sort by the last measurement in the columns - "AGG(FY Avg Volume (PE.." for one of the 3 FYs (the blue bar). If I create a discrete measurement to sort, result will not keep current hierarchy, which is BC (Group) > FY. Is there any way to sort while retaining current display hierarchy? Thanks a lot!

      I Sorting.PNG

       

      Emily