i have a pivot chart like this :
i need to trasform it in :
Can u help me pls?
Try using this expression:
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.
what about adding "Show partial sums" to the pivot table?
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?
See the attached example.
Retrieving data ...