1 Reply Latest reply: Oct 22, 2012 8:38 AM by Mayil Vahanan Ramasamy RSS

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

    Hamish Imrie



      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?