I have a pivot table as given below where the dimension field is Description
Description Actual Budget
Sales 10000 15000
less Purchase 6000 10000
Gross Profit 4000 5000
Staff Expense 2000 3000
Other Expense 1000 1000
Total Expenses 3000 4000
Profit 1000 1000
Expression for Actual is sun(actual) Budget is sum(Budget)
Now I want to calculate the rows highlighted in Red
Gross Profit= Sales-Purchase
Total Expense = Staff Expense+Other Expense)
Profit= Gross profit-Total Expense
Pls help me to calculate above rows in my pivot table
