6 Replies Latest reply on May 21, 2013 9:16 AM by lynda.kroeger

    Sort with hierarchy in place

    Vaidy Krishnan

      All,

       

      I'm facing a problem that I cant seem to resolve in spite of repeated attempts. My dashboard has a hierarchy i.e, Lets Say Category A (High Level), Category B  (low level)

       

      I'm pulling A and B into the rows and Sum(Amt) in the columns.

       

      Now I put a descending sort by amt on both A and B. When I collapse B, I see that amt is clearly sorted by A.

       

      But when I click the + sign the Sort on B doesnt seem to work. I know I'm doing everything right.

       

      I also tried creating a set A,B, sorting the set in descending by amt - and placing it between A and B. But again when I uncollapse, the set goes to the extreme right and the sort on B goes haywire.

       

      How do I solve this?

       

      Thanks for all your help!