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.


      regards,

      Salman