0 Replies Latest reply: Apr 23, 2013 5:46 AM by Fredrik Svensson RSS

    Ranking problem when selecting

      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?