Adding a Variance Field Row. Need Help

[ExcelWizard24]

Hello All,

I am trying to add a variance field between the Actual's and Open orders lines in my excel pivot table. I want it to automatically calculate the difference between the actual's and budget and insert a row between it. I know there has to be a way other than manually typing it on my source data.

I have used the calculate item and calculate field with no luck.

Would it be possible? Please advise.


Thank you for your help.

Untitled.png

[noboffinme]

Hi,

Can you advise why the Calculated Field didn't work?