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

[Anonymous]

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?

[MayilVahanan]

Hi

Try like this

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

Hope it helps