Calculate Column in a Pivot Table

[BaconMcSandwich]

My Pivot table calculates the following information from the raw data (below).

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. I can't seem to calculate "Enquiries/Sold*100" which is what I need to do.

 

[RoryA]

You'll need to use the data model and create measures to use anything other than SUM on fields in a calculation. Once you have measures using COUNT and MAX for the two source fields, your third measure can just divide one by the other.

 

[BaconMcSandwich]

You'll need to use the data model and create measures to use anything other than SUM on fields in a calculation. Once you have measures using COUNT and MAX for the two source fields, your third measure can just divide one by the other.

Cheers, can I ask if you can point me in the genral direction where to do this?

(Do I need Excel PowerPivot? (he asked after googling for a bit)

 

[RoryA]

Yes, you want PowerPivot - which you have if you are using 365.

 

[BaconMcSandwich]

Cheers. I'll have a look into that as see how I get on.