columns with percentage values in pivot tables

[Anonymous]

Hi all,

when working with pivot tables,I often liked to add some some columns with percentage values.

For example, now I have this:

but I would like to have something like this:

Does anyone knows if is it possible?

Thank you!

Sofia Vaz

[Anonymous]

Thank you Oliver. I understood your idea. However, is it impossible to present the % values only for totals and in a new column and in a new row, next to the total column and row?

I would like to have something like this:

[olivierrobin]

you could try  something like

if(dimensionality()=1, sum ()   & chr(10) & sum()/sum( total ), sum())

i mean :

for all dimensions, you compute the total

for dim 1, you concatenate the total and the pct