Pivot Table Add % Column

[inbp]

Hi Friends,


I have pivot table in which i have three columns,


Shop Name

Count of return transaction

Count of total transaction


i want to calculate the % of return transaction by dividing


return transaction/total transaction


this all i want to do in pivot, can any one guide me how i can perform this???


file attached below


https://www.dropbox.com/s/frc2bey72pe9exq/Pivot%20Table%20%25.xlsx


Thanks

 

[keymaster]

Hi Muhammad... see this post. Same idea applies to your situation as well.


http://chandoo.org/wp/2013/03/06/finding-conversion-ratio-using-pivot-table-calculated-items/

 

[inbp]

Dear Chandoo!


thank you for the reply...please look in to my file its slightly different. i tried my best to resolve but in vain.