Hi there
I have a pivot table that shows my actual values against what was budgeted, see screen shot attached.
Instead of the Grand Total column I would like a column that shows the variance between the Actual and Budget i.e. for 331020 Public Donations I would like to take the Budget value of £166 away from the Actual value of £137 to show an adverse variance of -£29.
Many thanks
Iain
Pivot.JPG
Bookmarks