Ignoring filter on dimension in aggr function

[#1]

Hi All,

I have an expression that uses and aggr function on dimension dim01. I also have provided the filter for dim01 on the same sheet. Now I want to have below expression calculated for all values of dim01 even if user have selected some values in dim01 filter. 

max(aggr(sum(facts), dim01))

Please advise.

regards,

Salman

[#2]

Hi,

use the below.

sum({<dimo1= >}facts)

[MK_QSL]

max(aggr(sum({$<dim01 = >}facts), dim01))

or

max({$<dim01 = >}aggr(sum({$<dim01 = >}facts), dim01))

[CELAMBARASAN · Accepted solution]

Try this

max({<dim01=>}aggr(sum({<dim01>}facts), dim01))