Creating Variances in Pivot Tables using hidden values or fields?

[PivotExcel2014]

I need some help adding a target value field inside a pivot table in excel.

Here is what my current pivot table looks like.

Regions 1 year - Actual 1 year - Target?? Difference
(April 2013 to March 2014) (Target - Actual)?
Region1 $6,355,696.75
Region2 $6,775,309.87
Region3 $2,230,424.76
Regions expand into managers which in turn expand to consultants.
What I want to do is add a column for target values of the 3 different regions and then create another calculated field that will show the difference between the target and actual values.
Can this be done without writing any stored procedures in SQL? I want to do this in excel itself.

The target values are not calculated so can we store them in hidden fields or something in the pivot or excel?

 

[scottsen]

I get the feeling you aren't using Power Pivot? What is PowerPivot? « PowerPivotPro (and if you are not... this probably isn't the best forum)