PivotTable:Using a calculated field result in another calculated f
 

I have a calculated field in the Data section. This field is a running total
across the row. The fieldname is YTDOrders. For each month across the Data
row,the running total is fine. I want to use this Calculated field in another
calculated field. Such as: NewYTDOrders, where the calculation would be
YTDOrders + 2.
Layout: Month1 Month2 Month3
Doors Orders 3 6 9
YTDOrders 3 9 18
NewYTDOrders 5 11 20 (this is what I need)
NewYTDOrders 5 8 11 (this is what I get)
It always refers to the Orders line, even tho the Calc is = YTDOrders + 2
ANy ideas to try would be vastly appreciated!
--
Thanks for the help!