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 Labels | SUM of Revenue | MAX of Cost | ROI |
| Campaign 1 | 299442.93 | 1627 | =SUM of Revenue / MAX of Cost |
| Campaign 2 | 1152022.37 | 2000 | =SUM of Revenue / MAX of Cost |
I am trying to do the least modifications to the source table. Any ideas?
Thank you in advance
