Get a percentage structure in pivot with tree

[#1]

Hello

I have a pivot table created from a structure in Excel and data related from a qvd

First i´m not sure if this is the correct way to get this, i've been looking for a while and i have not seen anyone with this needs, but i don't think it's complicated

I need the percentage structure of each row with respect to the upper level

But i can't get the sum of the upper level, this is what i need (E%)

I hope you can help me in this

Regards

[#2 · Accepted solution]

I time i implement something like this.

Sum(nValor)/

pick(dimensionality()+1,

Sum(total nValor),

aggr(Sum(nValor),concN1),

aggr(Sum(nValor),concN1,concN2))

try...

[#3]

Thanks rodrigo

With a little changes  IT WORKS !

I leave this here in case anyone need it

The final code was

Sum(nValor) /

Pick(Dimensionality(),

Sum(nValor),

Aggr(NODISTINCT Sum(nValor),concN1,nAnio),

Aggr(NODISTINCT Sum(nValor),concN1,concN2,nAnio),

Aggr(NODISTINCT Sum(nValor),concN1,concN2,concN3,nAnio))

[#4]

Goood!!!! its the ideia!

mark the correct awnser if corret for community stay organized! thanks