11 Replies Latest reply: Apr 30, 2015 1:20 PM by Jean-Rémy Ravina RSS

    Overall ranking within a table containing several dimensions

      Hello all,

       

      I have a pivot table with 2 dimensions (Field A is horizontal, Field B is vertical), and I need to get the global ranking through those 2 dimensions. For instance, I want to get the overall max value of this 2 dimensions table, the 2nd max value, 3rd... and so on.

       

      You can refer to the attached xls.

       

      Until now, with the rank() and hrank() functions, I only succedeed to compute the ranking per column or per row.

       

      Do you have any idea to compute this?

       

      Thanks,

      JR