Get variance between Forecast and Actual using Pivot Table

Hello everyone -

How do I get the difference between forecast and actual in my report using pivot table? I tried "Difference From" but to no avail.

Also, I would like to put some conditional formatting (RAG status) in weekly total of each project. Is that possible?

Hello,
Try to change the layout of data

I liked your output it meets my requirement. just a question, where i can find the "VTF" shown in the Pivot table?

Also, I want to get the USD value of Actual and Forecast by multiplying the hrs against the billing rate and get the variance in USD too.