| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Get Pivot Data
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro question | Excel Worksheet Functions | |||
| Inputting data to one worksheet for it effect another | Excel Discussion (Misc queries) | |||
| Refreshing Data within a pivot table | Excel Worksheet Functions | |||
| Data Cubes and Pivot Tables | Excel Worksheet Functions | |||
| Pivot table - printing specific data | Excel Discussion (Misc queries) | |||
Threaded Mode
