Problem incrementing GetPivotData formula

[Arkine]

Hello everyone

I have a GETPIVOT Data formula in A8
=GETPIVOTDATA("[Measures].[Name]",Total!$A$1,"[ValuesTable].[Employee ID]","[ValuesTable].[Employee ID].&[A0107733814033]")

But this doesn't increment because of the ID written so i've tried to modify it to:
=GETPIVOTDATA("[Measures].[Name]",Total!$A$1,"[ValuesTable].[Employee ID]","[ValuesTable].[Employee ID].&["&ROWS($A$8:$A8)&"]")

But it still gives me a REF error, any idea how to make this work?

Thanks again