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 !!! :




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




      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?