1 Reply Latest reply: Oct 22, 2012 8:38 AM by mayilvahanan ramasamy RSS

    Using Agg & rank across a time series (time on dimension axis of a chart)

    Hamish Imrie

      Hi,

       

      I am building a chart with a rank for each month in the year.

       

      My Dimension is a simple "Month Name".

       

      The below is my expression.

       

      =

      aggr(rank(sum({<ClientName=}>} Sales))

       

      I want to expand my expression to make my chart run across all the months. However if I amend this expression to produce that result, the expression produces the wrong result..

        

      aggr(rank(sum({<ClientName=, MonthName=}>} Sales))

       

      Any ideas how I can make this expression evaluate this for each month?