2 Replies Latest reply on Oct 21, 2014 5:28 AM by ankit godha

    need to multiple levels of ranking and show on the same sheet

    ankit godha



      Please see the screen shot below. On the same worksheet I need to show rankings at different levels. So below is the order spreadsheet. I am ranking all the customers by profit.


      They will have a rank in the whole population (if I select all the states) or they will have rank in each state.


      The table calculations are not allowing me to ignore the filter.


      So please play with the attached twbx and let me know how can I rank all the customers by profit and then show their rank in their state and in the whole population.