Valiant108
New member
- Joined
- Apr 28, 2012
- Messages
- 2
- Reaction score
- 0
- Points
- 0
In the Pivot Report the subtotal and total function works well except in
calculating the % variance in an income statement. The report tools
calculate the sum of each line % but what I want as a sub-total and grand total
is the total actual dollar minus the total budget dollars divided by the total
budget dollars for the total variance percentage. Not the column sub total
and grand total. How do I put a custom formula in for Excel 2007?
calculating the % variance in an income statement. The report tools
calculate the sum of each line % but what I want as a sub-total and grand total
is the total actual dollar minus the total budget dollars divided by the total
budget dollars for the total variance percentage. Not the column sub total
and grand total. How do I put a custom formula in for Excel 2007?