Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have calculated Variance (Actual_Budget) in my pivot table which is attache H/w
I want to the Variance to appear as follows
GROUP_DESCRIPTION
Actual
Budget
varience
SALES
100,000
150,000
(50,000)
COST OF SALES
40,000
70,000
(30,000)
GROSS_PROFIT
60,000
80,000
(20,000)
STAFF_EXPENSES
10,000
15,000
5,000
ADMIN_EXPENSES
2,000
3,000
1,000
SELLI_EXPENSES
4,000
6,000
FINAN_EXPENSES
1,500
500
TOTAL_EXPENSES
7,000
10,500
3,500
OTHER INCOME
4,500
(1,500)
NET_PROFIT
50,000
65,000
(15,000)
Favorable Variance should be green without brackets. But in my Pivot table it is shown within brackets
Pls correct my expression to suit my requirement