8 Replies Latest reply on Jun 2, 2016 2:09 AM by Nutan Patel

    Need grand total value as a calculation on filtered data (after applying filters)

    Nutan Patel

      Hello Experts,


      Total() function helps me to get total of measure value across the data source.  For example, If I want sum of sales (grand total of sales row wise), then Total(Sum(Sales)) will return me that.

      But what I want is to I want to get total of filtered data (example after applying few filters) as a calculated field.


      Any thoughts ?



      Nutan Patel