Excel and the getpivotdata function

[jeffmoore64]

Hi all,
I need to know how to use the NAME property when I use the getpivotdata function.
Here is an example of the issue:

Key value = "BMX"
Name vale = "BMX BIKES"

Here is what excell generates when I create the getpivotdata function:

=GETPIVOTDATA("[Measures].[Extended Price USD - S]",$A$3,"[Items].[SRP 5 - Category]","[Items].[SRP 5 - Category].&[BMX]")

What I need is something like this:

=GETPIVOTDATA("[Measures].[Extended Price USD - S]",$A$3,"[Items].[SRP 5 - Category]","[Items].[SRP 5 - Category]."&"BMX BIKES")

Any ideas on how to do this?

TIA