Rank min and max values

[chematos]

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

[swuehl · Accepted solution]

Try to rank for -sum([SSTT kg]):

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

[chematos]

I had thought something like that but I haven´t faith in a solution so easy....

Thank you swehl !!!