Calculated Dimension to exclude listbox selection

[Anonymous]

Hi all,

I have a ranking formula in my chart. The formula specifically needs to calculate the rank for a client on a particular month (which is no problem).

However the dimension now needs to force the chart to reproduce this for the whole time series.

Here is the expression formula

= 

aggr(rank(sum({<Client_Name=>} Sales )),Client_Name,CalendarDateYYYYMM)

However, I now need the dimension to evaluate all of the possible CalendarDateYYYYMM possible options.

Any advice on how to make a calculated dimension for CalendarDateYYYYMM  for all possible options.

As you can see, if I include this in the expression, my formula falls apart

[Gysbert_Wassenaar]

This should also ignore selections of CalendarDateYYYYMM:

aggr(rank(sum({<Client_Name=,CalendarDateYYYYMM=>} Sales )),Client_Name,CalendarDateYYYYMM)

[Anonymous]

Hi Gysbert,

Thanks, but this wont work (Have tried this already). The expression cant have the date restrictions removed in set analysis, this messes the ranks. It needs to be done completley outside - I am thinking in the Dimension of the chart...

aggr(rank(sum({<Client_Name=,CalendarDateYYYYMM=>} Sales )),Client_Name,CalendarDateYYYYMM