I am using the expression below, which give me the ranking, but if I make a selection, that fleet will allways be 1.
aggr
(
rank(total sum({$<Fleet= {"=aggr(sum(total <Fleet, PERIOD> {<TOTAL = {'>=$(Limit)<=$(Capped)'}>} YEARS ), Fleet) > $(vyears)"}>} TOTAL/ YEARS)), Fleet
)
But if I am using Fleet= in the Set Analysis expression, it will give me the rank of all the fleets corresponding to the current selection.
How could I use a condition, but still get the ranking when one fleet is selected?
