Create formula in pivot table

[Rohit Kumar]

Hi there,

I have an excel table and created a pivot fro it. Now I want to calculate a formula in pivot in which I want to divide summation of 1 column with average of other column. Please help.

Regards,
Rohit

 

[sgmpatnaik]

@Rohit Kumar

i think it is better to upload a sample file with your request and it is better to help you the forum reader and Ninja's

Thanks

SP

 

[Rohit Kumar]

Hi Patnaik ji,

Thanks for replying. Please find attached an example. I've created pivot table having sum of one column & average of other. Now I want to perform division command by dividing sum of first with average of other in pivot itself, but not able to do. Please help.

Regards
Rohit