Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Pivot Table Sum problem

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

1 Reply
Not applicable

Re: Pivot Table Sum problem

Oops tables not appearing in previous post.

ItemSales-2010 USD'000Sales-2011 USD'000
a178206
a21
a3868
a116
b4859
b53
b179211
b2234
b11
b23
b11
c796943
d164254
e01
e00
f97132
g5595
h4794
i3132
j00

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

ItemSum of Sales-2010 USD'000Sum of Sales-2011 USD'000
i132
j00
b9312
a7281
g195
h194
e01
c9943
d2254
f2132
Total322144

Why the sum of 2010 comes wrong?

Thanks

Sumant

Community Browser