Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Thanks a lot Manish
One more thing If I want to add following columns to Pivot Table How can I modify the expression
KP1 Actual Budget Variance Ach %
Sales 1000 2000 1000 50%
Variance=Budget-Actual
Ach % = Actaul/Budget *100