GETPIVOTDATA formula

[benfitz]

I am trying to create this formula (using Microsoft Excel 2007) in a separate sheet but it wont work. My formual so far is

=GETPIVOTDATA("Delay",'DRS103 PIVOT TABLE'!$A$3,"Code","MAC")

Can anyone see a problem here????

 

[GNB]

If you could post a sample of how your pivot table looks then that will help.