ROI on pivot table

Occasional Contributor



I am creating a pivot table where I would like to add a column with an ROI calculation.

I have investigated Calculated fields, but it seems that the only formula that they accept is SUM.

I've tried Value Field Settings, specifically Show Value As > % of...  But I get an #N/A.


This is the pivot table:


Row LabelsSUM of RevenueMAX of CostROI
Campaign 1299442.931627=SUM of Revenue / MAX of Cost
Campaign 21152022.372000=SUM of Revenue / MAX of Cost


I am trying to do the least modifications to the source table. Any ideas?


Thank you in advance

0 Replies