7 Replies Latest reply: Oct 22, 2013 2:55 AM by Christian Germeroth RSS

    Sum of calculated Column in Pivot

      Dear QV Community,

       

      i ve got a question, that seems simple on first sight, but i couldn't solve it by now, nor find a solution ...

       

      I have a pivot table, that contains 4 columns:

       

      Column1, Column2, Column3, Column4 (=Coulmn3 divided by Column2)

      A               2               2               1

      B               3               9               3

      C               4               16               4

      D               2               6               3

      Total   11             33          3

       

      The Problem i have is, that the total of column 4 ist calculated, insted of summed up.

       

      That sounds simple, but ...

       

      Any hints are so welcome!! Thanks in advance!!

       

       

      Chris