5 Replies Latest reply: Jun 17, 2015 11:40 AM by David Rodriguez RSS

    Different Total calculation in Pivot Table

      Hi all!!

       

      I have a pivot table and i need different total calculation depending the dimension.

      KPI_data3.jpg

       

      This is the expression:

       

      =AVG(TOTAL <MONTH_SHORT_NAME, HAUL> Aggr(SUM({<MIS_KPI_ID = {'AVO_PROMEDIO'}>} VALOR_KPI),MONTH_SHORT_NAME, HAUL))

       

      The total of HAUL (horizontal row) is an average, but the total of MONTH SHORT NAME (vertical column) is a SUM expression. How can i do this expression to make differents total calculations?

       

      Best Regards.