Pivot Table Sum problem

Fri, 21 Dec 2012 12:17:52 GMT

Plz help me solving this problem in sum in PIVOT table for following table

The result i get is correct for 2011 and not for 2010. What might be going wrong in my pivot.? I am using 2007 excel.

Its like following table

Thanks

Sumant

Re: Pivot Table Sum problem

Fri, 21 Dec 2012 12:27:24 GMT

Oops tables not appearing in previous post.

For this pivot result is as follows. for summation of each item for sales of both years.

Why the sum of 2010 comes wrong?

Thanks

Sumant