I am trying to insert a field into a pivot table calculated from two cumulative sums. I can't find how to create this calculated % based on cumulative values rather than the data solely for the row.
I have attached an example workbook.
I want to add the CumReturnRate (Cumulative return rate %) into the pivot table. Can anyone explain how to do this?
Thanks in advance.