• 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.

Not at all urgent

madocar

madocar

Member
Hello guys,

i need your help with Pivot table.

http://www63.zippyshare.com/v/85580632/file.html


I uploaded a file and there is a Pivot table with products and their conversion. The last column is conversion (sell) rate that is calculated like sold / number of goods. It is just an example. But the issue is the last SUM row and conversion rate. There is written it is 80 % but in fact it is 291 / 2350= 12,38%

The problem is that I dont know how to get 12,38 % number


Thank you in advance
 
madocar


If- you had read the green stick's who would have realized that putting Urgent in your title is a no no, it may be urgent to you but to the forum members who are busy with their lives it is not
 
@all

Hi!

Just passed by thru the topic and unwittingly pressed a few keys, I guess.

Regards!
 
Sorry,

haven't read that

I created new topic

thanks


EDITED


New topic:

http://chandoo.org/forums/topic/pivot-table-7
 
You must log in or register to reply here.
Back
Top