I have a row under my pivot table that contains the following formula:
"=GETPIVOTDATA("SERVICE COST",$A$13). I want this row containing this formula to move down every time data is entered on my table and updated on my pivot table where this row is located. This Row is not part of my pivot table. I would always want the row to move down 5 rows below any new information that comes in from my table. Can this be done? if so how would i do it?
Thank you,
Ruth