Hi
I tried changing to:
=GETPIVOTDATA($B$15&"","Trainee['a'] 'Test1' Level['2';Min]")
but still get a #ref error even before trying to reference any cells! Any
thoughts on where I'm going wrong?

Thanks

"Herbert Seidenberg" wrote:

Change the first argument from $B$15 to $B$15&""
See:
http://www.contextures.com
Excel -- Pivot Tables -- GetPivotData
Using Cell References For the Data Field in GetPivotData