Editing a formula that references a pivot to drag it down

Hi there

I have a pivot table with people's user ID, some summary data and two total columns at the end.
I have inserted a column at the beginning in Column A where i'm dividing one total by the other, to get a percentage.

I want the formula to reference the pivot table, because next month when I refresh the pivot, the total columns will have moved along. So I can't use =G7/F7 for example

However, the GETPIVOT formula is looking specifically the the user ID. See below example "N803057" is the user ID.

So when I drag the formula down (there are 112 users), it's simply dragging down the same user ID therefore dividing the same two cells. The only way I can change it is to manually enter the sum for all 112 rows (yawn) or manually change the user ID within the formula for all 112 rows (double yawn).

I tried changing the "N803057" to "=B7" which is the cell the user ID is in, but it didn't like that one little bit.

Does anyone have a suggestion??

PHP Code: 

=GETPIVOTDATA("Structure & Grammar Fail",$B$8,"User ID","N803057")/GETPIVOTDATA("Total Audits",$B$8,"User ID","N803057") 


Just change
"N803057"
to
B7
(no quotes or equals sign)

Thanks Stormin' this worked and saved me loads of time!

Jemma :-)