Pivot Table Totals Incorrectly Summed

[Ms MIS]

I have created a pivot table which contains calculated fields, for some
reason some of the column totals are summing up incorrectly

For example:

-1,075 0
90,725 90,725
-3,049 0
89,156 89,156
77,276 77,276
5,520 5,520
2,902 2,902
_______ _______
261,454 261,454
---------- -----------
Where in fact the second column should equal 265,578 as the two negative
figures do not exist in this column.

Does anyone have any idea why this may be happening?

Kind Regards,
Ms MIS

[Roger Govier]

Hi
I came across a similar problem with someone in another thread
yesterday.
I guess your calculated field is the second column of data, where you
have a formula something like
=IF (Amount < 0, 0 , Amount)
(in the other case, they were multiplying by a percentage, but only on
values >0)
There does seem to be a bug whereby the PT doesn't sum the individual
displayed amounts, but applies the criteria to the Total Sum of the
field i.e. it is saying =IF (Total Sum of Amount < 0 , 0 , Total Sum of
Amount)
As your Total Sum is greater than 0, then it is displaying the Total
sum.

The only way I can see round= the problem is to not use the calculated
field in the PT, but to add a column to your source data with the same
criteria, and drag this to the PT data area as well as your original
Amount

--
Regards

Roger Govier


"Ms MIS" <[email protected]> wrote in message
news:[email protected]...
>I have created a pivot table which contains calculated fields, for some
> reason some of the column totals are summing up incorrectly
>
> For example:
>
> -1,075 0
> 90,725 90,725
> -3,049 0
> 89,156 89,156
> 77,276 77,276
> 5,520 5,520
> 2,902 2,902
> _______ _______
> 261,454 261,454
> ---------- -----------
> Where in fact the second column should equal 265,578 as the two
> negative
> figures do not exist in this column.
>
> Does anyone have any idea why this may be happening?
>
> Kind Regards,
> Ms MIS
>