Discussion board where members can get started with QlikView.
I have following data and I am trying to plot a simple pivot table which will give me the sum-total for Row4.
I am using Row1, Row2 and Row3 as my Dimension. (these 3 fields has to be in Dimension only)
Issue is I am not getting the sub-total at the bottom for Row4 even when I do Presentation->Row1->check Partial Sums.
Tried to do the same thing with Row2 and Row3 as well.
Load * inline[Row1, Row2, Row3, Row4A, Test, Apple, 100A, Test1, Banana, 200A, Test2, Orange, 300];
What I want:
Need the same in Pivot chart only, can't move to Straight chart
If you have Row1, Row2, Row3 as dimensions and Sum(Row4) as a measure, it should look like this when expanded.
View solution in original post