2 Replies Latest reply on Jun 8, 2016 6:24 PM by Srikanth Baskaran

    Grand Total- affected by filters

    Srikanth Baskaran

      Hi

       

      I'm trying to calculate the grand total for the data set and I need this unaffected by any filters.

       

      example:

       

      I'm calculating the total sales for all the order dates using table calc but when I filter out the dates it changes. Is there a way we can have it unchanged even when the filters are applied?

       

      Thanks

      Srikanth