3 Replies Latest reply: Oct 14, 2014 5:04 AM by Celambarasan Adhimulam RSS

    Ignoring filter on dimension in aggr function

      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.