Get Pivot Data

B

Benjamin B

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
 
D

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Get pivot data / V/Hlookup 1
Copy data from pivot table using relative reference 5
Grouped Cells in Pivot Tables 0
Pivot Tables - Can you just list data and not SUM 2
Possible getpivotdata with offset? 1
get pivot data 0
Help Please-get pivot data 0
Conditional array not working with pivot table data - what am Imissing?? 1

Top