Hello I would like to create a calculated field the projection of an annualized figure, so that
[Annualized figure] = [year-to-date value] + [projection]
is true.
I have a date column spanning three years and a column to sum up. Basically it would look like this:
Row Labels Year-to-date value projection grand total (the annualized figure)
2013 100 0 100
2014 130 0 130
2015 70 75 145
What would the calculated field be for the projection column within the pivot table? Something based off my date and year-to-date value obviously.
Bookmarks