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

    total in pivot

      Hi,

       

      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

       

      Immagine.JPG

       

      Andrea

        • Re: total in pivot
          Jonathan Dienst

          Hi

           

          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

          Jonathan