Pivot chart values aggregate

[#1]

Hi all,

i have a pivot chart like this :

Roles	Sex	N° Emp
A	Man	2
	Woman	3

i need to trasform it in :

Header 1	Header 2	Header 3
A	Man+woman	5
	Woman	3

Can u help me pls?

tyvm

[sushil353]

Try using this expression:

rangesum(Below(sum(temp),0,RowNo()+1))

HTH

Sushil

[DavidFoster1]

I dont think you can do this directly in the pivot table. You will need to change the data model to derive what would be a need value for the Gender dimension.

[salto]

Hi,

what about adding "Show partial sums" to the pivot table?

[#5]

Hi,

See the attached example.

[#6]

I have to show without partial sum row, but it could be right.

Can i use the value of partial sum in other char? can i save it in a variable?

tyvm