BaconMcSandwich
New Member
- Joined
- Jun 14, 2021
- Messages
- 16
- Office Version
- 365
- Platform
- Windows
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.
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.