Forum Discussion
Calculated Field on Pivot Table
Hey. I have built a Pivot Table that shows me Leads and Opportunities created in each month. I can break down these Leads and Opportunities per source. I'm trying to create a calculated field on the pivot table that gives me the conversion rate per source. But I can't seem to do it.... I would need a new column on the Pivot Table that gives me Count of ID Op/Count of ID Lead. Can it be done?
If you are on Windows it's better to add data to data model creating the PivotTable and use proper measure which shows the division.
