Hello,

I have pivot table with inventory data, such as category, part number, quanitty 1, quantity 2, etc. Just outside the pivot table i have a column called "Quantity Counted", which will be manually entered, Next column is "Variance"

What I want to add the two data fields from the pivot table "Quantity 1" & "Quantity 2" and then subtract the quantity counted in the variance column. When i drag the formula down, the values do not change.

I think the trick is to replace the some of the fields values with the cell referenc, but because the pivot table is a bit hierarchial, I am not sure what values to tamper.

Thanks
SJ