2 Replies Latest reply on Aug 23, 2016 4:37 AM by Sanket Deshpande

    Maintain Grand Total after Action Filter

    Sanket Deshpande

      Hi all,

       

      I have read many posts to maintain denominator grand total for percentage  even after applying filter by using the  formula

      Lookup(max(Dimension),0).

       

      found this from this post .Re: Filter that keeps Grand Total as denominator

       

      However my problem is im passing the dimension by using an action filter. As a result of which the Lookup function fails.

      What can be an alternate solution for the same.

       

       

      Thanks in advance,

      Regards,

      Sanket