3 Replies Latest reply on Dec 21, 2016 11:23 PM by koushik.neelakantha

    Sum of Grand total

    koushik.neelakantha

      Hello everyone,

       

      I need to get the Sum of Column Grand total.

       

      For sub totals i am taking average of the measure but my grand total should be sum of the Subtotals not the average.

       

      Calculation:

       

      if first() = last () then AVG([Last 12 Months Sales]) END

       

       

      Regards,

      Koushik.