Actual Column / Budget Column / Variance Column

[#1]

In the attached example I have a column "Expense Type" which has actual and budget.  I am trying to have a column with the actual expenses, then a column with budget expenses and a final variance column.  Any suggestions?

[johnw · Accepted solution]

Perhaps this:

Actual = sum({<"Expenses Type"={'Actual'}>} "Expenses Amount")
Budget = sum({<"Expenses Type"={'Budget'}>} "Expenses Amount")
Variance = Actual - Budget

[#3]

Thank you very much!