Pivot Table Sum problem

[#1]

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

[#2]

Oops tables not appearing in previous post.

Item	Sales-2010 USD'000	Sales-2011 USD'000
a	178	206
a	2	1
a	38	68
a	11	6
b	48	59
b	5	3
b	179	211
b	22	34
b	1	1
b	2	3
b	1	1
c	796	943
d	164	254
e	0	1
e	0	0
f	97	132
g	55	95
h	47	94
i	31	32
j	0	0

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

Item	Sum of Sales-2010 USD'000	Sum of Sales-2011 USD'000
i	1	32
j	0	0
b	9	312
a	7	281
g	1	95
h	1	94
e	0	1
c	9	943
d	2	254
f	2	132
Total	32	2144

Why the sum of 2010 comes wrong?

Thanks

Sumant