Macro to calculate using the fields in pivot generated

[archanair]

Hi Friends ,

I am very new to creating macros using vba code .I tried a macro to create a pivot table .so now I need to Completion % calculation field .

Eg .My pivot table looks like this

I want to calculate completion rate for all locations in row 10 individually (eg. Gurgaon completion rate will be 3/52).This calculation row should appear once I click a macro to calculate )

thanks

 

[anishms]

I tried a macro to create a pivot table .so now I need to Completion % calculation field .

Hi,
Is this pivot a result of your code and are you looking for the code for completion % in continuation to that?. if so, it would be better to share a sample file to look at
or
The code is required only just to calculate completion % ?