Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try to rank for -sum([SSTT kg]):
IF(AGGR(RANK(-SUM([SSTT kg])), [SSTT kg]) <= $(Nmin), [SSTT kg])
Try to rank for -sum([SSTT kg]):
IF(AGGR(RANK(-SUM([SSTT kg])), [SSTT kg]) <= $(Nmin), [SSTT kg])
I had thought something like that but I haven´t faith in a solution so easy....
Thank you swehl !!!