Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
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, Row4
A, Test, Apple, 100
A, Test1, Banana, 200
A, 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.
If you have Row1, Row2, Row3 as dimensions and Sum(Row4) as a measure, it should look like this when expanded.