Bottom Rank

[Anonymous]

Trying to show bottom 10 ranked values by using calculated dimension:

=if(Aggr(Rank(-(sum({<Week={"<=$(vCurrentWeek)"}, Year={$(vCurrentYear)}>} Sales)-

                sum({<Week={"<=$(vCurrentWeek)"}, Year={$(=vCurrentYear-1)}>} Sales))), Clients) <= 10, Clients)

It work fine as long as the resulting value is negative but doesn't show if it's 0 or positive.

[#2]

The easiest way of doing this is using the Dimension Limits tab from the graph:

[rustyfishbones]

=if(Aggr(Rank(-(sum({<Week={"<=$(vCurrentWeek)"}, Year={$(vCurrentYear)}>} Sales)-

                sum({<Week={"<=$(vCurrentWeek)"}, Year={$(=vCurrentYear-1)}>} Sales))), Clients) <= 10, Clients)

Try without the - before sum

=if(Aggr(Rank(sum({<Week={"<=$(vCurrentWeek)"}, Year={$(vCurrentYear)}>} Sales)-

                sum({<Week={"<=$(vCurrentWeek)"}, Year={$(=vCurrentYear-1)}>} Sales)), Clients) <= 10, Clients)