Calculated Field: Annualization

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:

Please Login or Register  to view this content.

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.

Hi,

Can you please upload a sample sheet with the desired result?

Hi Shareez,

Please take a look at the attached workbook. I found a way to do it in the PowerPivot Add-in for Excel 2010 (at least I think it's right, not 100% sure on the math yet). See the following Measure formula:

Please Login or Register  to view this content.

Breaking the formula down... if the year of the data item is the same as the current year, do the annualization, otherwise (completed past years) return zero. The math inside the annualization is the hard part, to me anyway. Does this look correct logically?

Please Login or Register  to view this content.