Can't get a sum-total when using multi-dimension in pivot table

[sayadutt]

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

[Lisa_P · Accepted solution]

If you have Row1, Row2, Row3 as dimensions and Sum(Row4) as a measure, it should look like this when expanded.