2 Replies Latest reply: Apr 20, 2012 3:32 PM by Jose Tos RSS

    Rank min and max values

    Jose Tos

      Hi,

       

      I want to do a ranking of the top X and the less top Y, you know? The X max values and the Y min values of a chart.

       

      IF(AGGR(RANK(SUM([SSTT kg])), [SSTT kg]) <= $(Nmax), [SSTT kg],

      IF(AGGR(RANK(SUM([SSTT kg])), [SSTT kg]) <= $(Nmin), [SSTT kg]))

       

      I need to change the second IF to get a number of minimum values

       

      Any help would be appreciated.

       

      Regardas,

      Chema