Hi,
I have a pivot table with ten rows and a Total.
I want to place a formula near the total row ( the formula is not dependent on the pivot table values-lets say that the pivot table values are income value and the formula near the pivot table is expenses value from another worksheet)
when i refresh the pivot table and new rows are added to the pivot table the the cell with the formula that was near the total row of the pivot table is not on the same row of the total anymore.
How can I keep the formula on the same row?

Thank you,
Yossi