pivot formula

[kamblekamble]

Hi All,

I have below pivot table, Please refer the last column which I make manually, Please let me know how can apply this formula in pivot table.

[TABLE="width: 723"]
<colgroup><col><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]Count of Contact Dtails[/TD]
[TD]Column Labels[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]MEs %[/TD]
[/TR]
[TR]
[TD]Loction[/TD]
[TD]Bronze - Zero[/TD]
[TD]Diamond - Rs 5000[/TD]
[TD]Gold - Rs 2500[/TD]
[TD]Paid 200/500[/TD]
[TD]Silver - Rs 1000[/TD]
[TD]Grand Total[/TD]
[/TR]
[TR]
[TD]Thane[/TD]
[TD]92[/TD]
[TD]4[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]4[/TD]
[TD]100[/TD]
[TD]29.15%[/TD]
[/TR]
[TR]
[TD]Andheri[/TD]
[TD]38[/TD]
[TD]2[/TD]
[TD]1[/TD]
[TD]5[/TD]
[TD]4[/TD]
[TD]50[/TD]
[TD]14.58%[/TD]
[/TR]
[TR]
[TD]Bandra[/TD]
[TD]43[/TD]
[TD]4[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]47[/TD]
[TD]13.70%[/TD]
[/TR]
[TR]
[TD]Borivali[/TD]
[TD]39[/TD]
[TD]1[/TD]
[TD] [/TD]
[TD]4[/TD]
[TD]1[/TD]
[TD]45[/TD]
[TD]13.12%[/TD]
[/TR]
[TR]
[TD]Dombivli[/TD]
[TD]38[/TD]
[TD]3[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]41[/TD]
[TD]11.95%[/TD]
[/TR]
[TR]
[TD]Chembur[/TD]
[TD]31[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]4[/TD]
[TD]35[/TD]
[TD]10.20%[/TD]
[/TR]
[TR]
[TD]Malad[/TD]
[TD]13[/TD]
[TD]10[/TD]
[TD] [/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]25[/TD]
[TD]7.29%[/TD]
[/TR]
[TR]
[TD]Form Not Received[/TD]
[TD]23[/TD]
[TD]1[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]1[/TD]
[TD]343[/TD]
[TD]100.00%[/TD]
[/TR]
</tbody>[/TABLE]

 

[DaveBlakeMAAT]

If you add the grand totals values to you pivot table "values" area twice, and then on the 2nd 1 click the dropdown arrow and select Value Field Settings, click show values tab and select % of column total.