Problem with changing absolute references in GETPIVOTDATA function with OLAP Pivot Table

Hello,

I’m trying to change the absolute references that are returned by GETPIVOTDATA with cell references on an OLAP PT.

Here's what I get back automatically:

=GETPIVOTDATA("[Measures].[Volume]",$A$3,"[Month].[Month]","[Month].[Month].&[11]","[Organization].[Org Hierarchy]","[Organization].[Org Hierarchy].[Org Level 3].&[[90049535]] US CBD TOTAL]","[Month].[Month Role]","[Month].[Month Role].&[11]","[Product].[Sector]","[Product].[Sector].&[[000000001]] FABRIC&HOME CARE SECTOR]")

I need the Product.Sector field to be a cell reference, but when I make the changes below, I get a REF error:

=GETPIVOTDATA("[Measures].[Volume]",$A$3,"[Month].[Month]","[Month].[Month].&[11]","[Organization].[Org Hierarchy]","[Organization].[Org Hierarchy].[Org Level 3].&[[90049535]] US CBD TOTAL]","[Month].[Month Role]","[Month].[Month Role].&[11]","[Product].[Sector]","[Product].[Sector].[" & B8 & "]")

Any help would be greatly appreciated!

Thanks!

Hi, Do you think its possible for you to post a sample file.
Best Regards/VKS