Pivot calc field

I have a pivot table based on table with 4 cols:

Region > 10 different regions

Period > month of year, expressed as 1 thru'12

Value > any value

BA > B [for Budget], A [for Actual]

Table is 000's of rows.

Pivot shows 2 value columns for A and also B.

That's the easy bit.

Want another column in the pivot showing the difference between B & A, so if
B=1000 & A=950, the new column will show 50.

Have searched help, the web and books.

Still haven't a solution.

Is there a solution?

Should be simple - shouldn't it?

Help please.

I have never been able to resolve this without creating two additional columns, Actual and Budget, and either a column called variance or a calculated field for variance.

Assume Column B has the actual/budget flag and Column C has the $value.
Populate the the new Actual column with something like
=if(b2="A",C2,0) ... and equivalent for the new budget column.

If there is a better way I am keen to know it also. It get even more fun if you want month and year-to-date in same pivot report :-(

regards..

You should use a calculated item. To do this right click on BA, then
go to Formulas, then Calulated Item. Fill the formula B - A into the
formula bar and enter a name. Then format to thousands if desired.