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 ?

       

      Thanks

      Nutan Patel