Hi there, and welcome to the forum!
You know, it's interesting that you should ask this question... I JUST published a video course this week that covers this topic. If you're interested it is currently on an introductory special... you can find out more about it here.
To your question, what I would do is insert a new calculated field so that it gives me the variances for each line as well as the subtotals. To do that:
- Go to PivotTable Tools --> Options
- Select Fields, Items & Sets --> Calculated Field
Set the values as follows:
- Name: Budget
- Formula: =(Actual-Budget)/Budget
Now click Add, and you should be done.
Hope it helps,
Bookmarks