Mar 31 2022
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:
I am trying to do the least modifications to the source table. Any ideas?
Thank you in advance