14 Replies Latest reply on Feb 20, 2017 4:39 PM by ranjit saha

    Ranking within Hierarchy

    Mahesh Ruikar

      Hello,

      I have a need of ranking my numbers within a hierarchy. Attached is a superstore workbook which shows what I want to achieve. In the attached version, I am able to rank only the states by sales. However, when I click on cities for next level of hierarchy, the ranking gets messed up. How can I keep the ranking at both the levels? My real data has 4 levels. Director/Group Manager/Manager/Associate and I need to rank them all by sales numbers within that hierarchy.

       

      Thanks in advance for the help.

      - Mahesh