Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
use the below.
sum({<dimo1= >}facts)
max(aggr(sum({$<dim01 = >}facts), dim01))
or
max({$<dim01 = >}aggr(sum({$<dim01 = >}facts), dim01))
Try this
max({<dim01=>}aggr(sum({<dim01>}facts), dim01))