6 Replies Latest reply: Jun 9, 2015 11:19 AM by David Rodriguez RSS

    Aggregate function

      Hi all!

       

      I have a pivot table with a conditional expresion, one of the calculations is an Aggr function, the expression works, but when i'm going to do drilldown for a different dimension, the value of the dimensions are the same, only shows the total value.

       

      How can i create this expression?, i need to do drilldown.

       

      This is the expression:

       

      =if(MIS_KPI_ID='LF',

             (

            Sum(TOTAL <MONTH> Aggr(Sum(TOTAL <MONTH,MIS_KPI_ID,CIA_KPI> {<MIS_KPI_ID = {'RPK'}>} VALUE),MIS_KPI_ID,MONTH,CIA_KPI))

            /

             Sum(TOTAL <MONTH> Aggr(Sum(TOTAL <MONTH,MIS_KPI_ID,CIA_KPI> {<MIS_KPI_ID = {'ASK'}>} VALUE),MIS_KPI_ID,MONTH,CIA_KPI))

        ),Sum(VALUE)

      )

       

      ...and this the result of the pivot table:

      KPI_data2.jpg

       

      Thanks for the help.

       

      Best Regards.