• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Pivot Table Add % Column

I

inbp

Member
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
 
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/
 
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.
 
You must log in or register to reply here.
Back
Top