How To include Percentage include with Total in Pivot Table

[SatyaPaleti]

Hi Folks,

I have created Pivot table. I have dimensions Categories, Year an Expressions Sales and Target. When I am doing Partial sum on Year

it showing Sum of Sales and Target but I need to show Percentage between Sales and Target Including with Total. Here is the below screenshot. for more reference please find attached qvw

Thanks and Regards,

Satya

[vishsaggi]

Not completely sure if this would suffice your requirement but a work around would be using dimensionality function. Check attached.