I have a table which has a date column, and a percentage column. What I would like to put in my pivot table is the product(1+percentage)-1, i.e. the cumulative percentage over the period. I can't figure out how change the value formulas. Is there any way to do this?
Bookmarks