Total value showing wrong in pivot table

[Anonymous]

Hi,

I am calculating sum of sales value, the total showing in the pivot table is different from the total in excel. Sales values are both positive and negative.

For eg; the total i got from pivot table is 35971.85 but the same calculated in excel showing 36033.07.

[tamilarasu]

If you can create one sample file and attach here, you might get a solution easily. It is difficult to answer your question by just seeing the values.