Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try using this expression:
rangesum(Below(sum(temp),0,RowNo()+1))
HTH
Sushil
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.
Hi,
what about adding "Show partial sums" to the pivot table?
Hi,
See the attached example.
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