8 Replies Latest reply on Apr 29, 2018 4:21 AM by Ritesh Bisht

    RANK as per Dynamic Hierarchy

    Deepika Goyal

      Hi All,

      Need help in below scenario

       

      I have created  hierarchy  [Region --> Category --> Branch Name]   and showing it in the row. There is one measure called growth on which i want to create Rank.

      Hence, have created one measure called Rank1 (  formula: RANK( sum([Growth]), 'asc')) and using to show rank, restarting at each category.

      snapshots for the same have attached

       

      Problem statement:

      This work fine, but when i drill up on my hierarchy it throws an error "Table calculation requires a field that is missing".  Basically, growth Rank should work on all my said hierarchy

       

      Thanks.

      Deepika