Hi, In my pivot chart I want a column that shows the difference between a cumulative budget and cumulative actual column. I have created these cumulative value columns by using the Field Setting/Use data/'Running Total In' facility. However when I try and use the Calculated Field function so that I can minus one field from the other these fields are not available in the list to choose from. I assume Excel does not see them a real fields. How can I get around this?
My Pivot should look like this
Month Actual Budget Cumulative Actual Cumulative Budget Cumulative Difference
Jan £1000 £500 £1000 £500 -£500
Feb £1250 £2500 £3250 £3000 £250
Thanks
My Pivot should look like this
Month Actual Budget Cumulative Actual Cumulative Budget Cumulative Difference
Jan £1000 £500 £1000 £500 -£500
Feb £1250 £2500 £3250 £3000 £250
Thanks