4 Replies Latest reply: Oct 26, 2012 8:22 AM by Andrea Rebora RSS

    total in pivot

    Andrea Rebora



      as you can see in the below image, the total in the last column is calulculated by 161*114, not by the sum of 5.459+3.679.

      How I can set partial sum as I want?


      Many thanks





        • Re: total in pivot
          Jonathan Dienst



          You will need to use an Aggr() expression for your table. It will look something like:


               =Sum(Aggr(  ... your current calculation here ... , Dim1, Dim2, Dim3, ...)


          For example


               =Sum(Aggr(Sum(Amount * Factor), ClientID))


          Insert your current expression in ... your current calculation here ... and the pivot table dimensions in Dim1, Dim2, etc.


          Hope that helps