Total of sub dimension in a dimension

[gbechard]

Hello

I need to sum in a pivot the sub catgory.

This is what I get in QView :

This si what I would like (see red frame) => Any Idea how to do this ?

Thanks a lot

[Anonymous]

Hi,

Go to Chart Properties:>Presentation tab:>Select Show Partial  Sums > which ever dimension you want

Hope it helps!!

[gbechard]

Thanks  Anil

This is what I did, but the result is first screenshot, not the second one

(See QV File)

[sunny_talwar]

Maybe this:

[#5]

check this.

[gbechard]

Hello

Thanks, but this does not solve my issue since you took all intermediary dimensions off.

[sunny_talwar]

Did you look at what I proposed above? Not good?

[gbechard]

Thanks Sunny
This is very helpfull and smart .

The thing is that I have 17 KPIs and need to implement other dimensions on demand which makes this usefull solution hard to implement.
If there is no other solution, I'll implement this.