I am trying to insert a calculated field into a pivot table to calculate average annual growth. The formula I have been using works fine when not using a pivot table, but not when I try to insert a calculated field into a pivot table.
=('2017 Budget'/'2012')^(1/6)-1
Any suggestions?
Bookmarks