Dimension as label for partial sums in pivot table.

[pavan045]

Hi everyone,

I have a pivot table which need which have 2 dimensions. for the second dimension I am taking partial sums. For partial sum label I wanted to show the corresponding first dimension instead of 'Total'.

In pressentation tab we have 'label for partial sum' option, in which we can write expressions. Any one help me with that?

Thank you.

[Kushal_Chawda]

But Your Product Might be a Master Table so can join that table to sales table

[Kushal_Chawda]

Or instead of join use apply map to bring product and group in sales table