15 Replies Latest reply: May 16, 2017 9:35 AM by David Pardoe RSS

    Top 25 using rank and/or aggr functions

    David Pardoe

      I can't see the wood for the trees. I have a PEOPLE table with a field SALES_LAST_PERIOD. I would like an expression that provides the rank for the people in terms of their SALES_LAST_PERIOD.

       

      When I create a table and include a "measure" column with the expression: rank(SALES_LAST_PERIOD) I always get a 1 in the table for every row.

       

      If I try to add a "dimension" column with the same expression I get "invalid dimension"

       

      This seems a bit obvious to me?!

       

      Ultimately I want to use set analysis to compare a metric for a PERSON with the avergae metric for the top 25 people based on their sales.