Including Named Range in Calculation Field through VBA

[_eNVy_]

Hi all,

Newbie to the forum here.

Wondering if it is possible to include a Named Range within a Calculated Field in my Pivot Table.
The Named Range is "Period".


Essentially, I require a calculation which looks at the field "Actual Entered Amount" / "Period" * 12. This field would then be cased "Forecast".
Based on what "Period" the End-User enters, it will Forecast the remaining months in order to get a total.

Is this possible?

More Info : Pivot Table Name : PivotTable2 (can and will be changed later)

Thank you in advance,

NV