Pivot table calculated field

[nparsons75]

I have a pivot table which takes data from a main table. I also need to add a custom calculated field to add the result of a formula on another sheet. On the other sheet there is a calculation that has a result of as an example 40.

I need this result to show in my pivot table in a column of its own (column A). So each row in the pivot table will be = to 40 in this column (Column A)

Appreciate any thoughts, thanks.