11 Replies Latest reply: May 16, 2017 6:25 PM by Stefan Wühl RSS

    Using Rank and ignoring selections

    David Pardoe

      I'd like to use Rank but ignore my selections.


      I am using the following expression:


      AVG(Total {<CONSULTANT_ID = {"=Rank(SUM(TS_CON_HR_FEES_SUM_L123))<=5"}>}[TS_CON_OT_JOBS_CNT_L123])


      which works perfectly until I make selections and then the rank works on the selected consultants - I want it to continue to use the whole data set. I know {1} denotes the whole data set ignoring selections but I don't know where to put it in the expression above.


      As an extension I would like to perhaps retain some dimensions that have been used. For example there is an OFFICE dimension and if an OFFICE has been selected then I'd like to use that selection before I rank my top 25.


      Please help me - I have been battling all day with this!