How to use Total<> for 100% when I change dimension position

[#1]

Hello,

How can I use total<> , when I allow pivot in pivot table and the % total still show 100% like in pic1

(but now this table show like pic2)

and code >>>> total<Cyclicgroup>

(Cyclicgroup = PP, BBB, TTT)

Many thanks

[oxiofrt]

Hi,
can u send a qvw ?
Franck

[#3]

Many thanks for your help

[oxiofrt]

Well, I may help but am not sure what result you are waiting for.

Can U export your table to Excel, add a column filled with the awaiting values and then send it ?
(please identify the ne column with a specific color code)

[#5]

I try to calculate % in 100% on total(gray line) for all pivot type on pivot table that allow pivot

[oxiofrt]

Sorry I am French and not sure to have understood " try to calculate % in 100% on total(gray line) for all pivot type on pivot table that allow pivot" but I hope qvw herejoined is what you are waiting for... It is exactly the same as what your excel file contains.

If not please modifiy the Excel file so that I can have no doubt about your goal.

[#7]

FYI

This is what I try to do

[oxiofrt]

We will do it....

Still have difficulties to understand "I try to do % in 100% for all total level because I allow user to pivot this table".
In the hereafter table, are blue cells wrong ?
You would like to have 100% in all total cells (as shown in red cells) ? (would be strange...)

What value are you expected your last Excel file for cells :
D22 , F23, H26

[#9]

I try to calculate all blue cell show in 100%

(not just only this blue hilight cell but for all total level)

[oxiofrt]

Maybe the dimensionality function could help.

I am still not sure what result you are expecting. please provide exactly the awaited values in your excel file if the qvw herejoined is not what you are waiting for, so that there can't be any misundersanding.