GETPIVOTDATA function
Posted by John S. on February 13, 2001 6:16 AM
I need to know the correct way to get pivot data. EX:
Row: Apples,Red,Washington,
Data: Sum of Sales
I need to get the sum of the Red Apples Sales from this pivotdata using ref. cells
A1=Apples
B1=Red
getpivotdata(Pivot1,A1&" "&B1 Sum of sales)
this is not working. help thanks