7 Replies Latest reply: Dec 9, 2014 12:44 AM by Anand Chouhan RSS

    pivot table total issue

    Bunny V

      pivot performance total.PNG.png

       

      Here in this pivot table i m having the issue with the Performance Total it is varying .

       

      It should be Sum([Coperate SLP])*[Performance])

       

       

      Means (103*106)+(0*111)=109.18 but its displaying as 111 that is the problem over here.

       

      Help me guys since a week i m striving to get it done but its not getting perfect.

       

       

      i have attached the expressions also .