Discussion board where members can get started with QlikView.
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
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?