Get Pivot Data

[Guest]

When the value in a pivot table field is blank (as below) what is the
expression in the GETPIVOTDATA formula that returns $0.10 instead of $0.40?

Main Unit Revalue R vs NR Jul-06
Sales (blank) R $0.10
NR $0.30
Sales Total $0.40

=GETPIVOTDATA(PIVOTS!A3,"salesâ€) returns $0.40

Since I want to extract the value $0.10 I would normally write

=GETPIVOTDATA(PIVOTS!A3,â€sales (blank) ‘7/1/2006’â€)

But in this instance that returns #REF! or #NA

 

[Debra Dalgleish]

I don't know of a way to return a value for (blank) in Excel 2000 (it
works in Excel 2003).

You could select the (blank) heading and type another heading there,
even just a space character. Then use that value in the GetPivotData
formula.