2 Replies Latest reply: Jan 26, 2012 10:18 AM by Jörg Lortz RSS

    Please help... SUM / AGGR in Pivot table is wrong!!

      Hi everybody!

       

      I have a question...

       

      I created a pivot chart / table with a formula (I want to SUM()  3 different "elements" ("SB","SKY","MREC") and want to display the max one daily based.).

       

      But if I'm checking the values the total sum (autogenerated) is WRONG !!! :

       

      111.gif

       

      If I'm calculating (sum) the values manually (or in ms-excel), I will get another result:

       

      222.gif

       

      I thinks this happens because the formula is still in this field while autogenerating the sum()-Line.

       

      Is it possible to autogenerate the SUM() without using the formula in this field?

       

      thanks,

      jup