Total related problem in Column of Chart

[#1]

I want to add subtotal of one Column,But it takes total of next column.

(In Chart Properties->Presentation Tab->Select Dimensions and Expression,Tick on Show partial sum)

But it takes next column total.

[#2]

Thanks,

But I want this total in Dimension Column.

In dimension column,there is no expression.

[#3]

For  more Clarification

takes an example..

I have three dimension in pivote chart

Material Type

Material Code

Material Group

If I tick show partial subtotal for all three fields.

for Material Code, it takes subtotal of Material Type

for Material Group,it takes subtotal of Material Code

Thanks ....

[Gysbert_Wassenaar]

Well, I understand it can be a bit confusing, but the partial sum show the total of the column where you enable partial sums. So for the first dimension (the left-most column) it returns the chart total. For the second dimension it returns the total of that column for each value of the first dimension. So for the second dimension you see subtotals for each value of the first dimension. And so on for the other dimensions. When you think about it a bit you'll see that it actually makes sense. And that doing it differently wouldn't really work. You wouldn't be able to create an overall total and the right-most dimension couldn't have a partial sums option.