Excel Pivot Table Help

[Stuart_C]

My Pivot table calculates the following information from the raw data (below, inclucding how the data is being displayed in the pivot table).

 

I want to insert a caclulated value in column F that works out the percentage on enquiries that were turned into sale. But I can't work out how.

 

I can insert calculated fields that work based on the sum of fields, e.g. I can multiply the profit by 10, or the sum of enquiries by 10. But both of which are useless but work. I can't seem to calculate "Enquiries/Sold*100" which is what I need to do.

 

[David44]

So, what happens if you enter =(E1/D1)*100 in cell F2?

[Stuart_C]

I realise typing the formaula manually might work rather than clicking in cells where it auto fills in Pivot table stuff and doesn't work.

 

It's quick and dirty so it will do for now.

Cheers