ROI on pivot table

Occasional Contributor

Hello,

 

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