Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table Data
I have learned to use GETPIVOTDATA to retrieve numbers aligned with employees
names. When an employees name does not appear on the pivot table, it returns #REF!, which can be turned into 4 with the ERROR.TYPE command. I can turn the 4 into a 0, but then when the number is not a 4, I get #N/A. Is there any way to get a 0 off of the pivot table if an employee name does not show up? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table Data
You can wrap the GETPIVOTDATA formula inside another function to return zero
if GETPIVOTDATA returns an error. In Excel 2007 you can use IFERROR: =IFERROR(GETPIVOTDATA(...),0) In Excel 2003 & earlier, you can use an IF(ISERROR( construction: =IF(ISERROR(GETPIVOTDATA(...)),0,GETPIVOTDATA(...) ) Replace ... with the arguments for your GETPIVOTDATA formula. Hope this helps, Hutch "ms" wrote: I have learned to use GETPIVOTDATA to retrieve numbers aligned with employees names. When an employees name does not appear on the pivot table, it returns #REF!, which can be turned into 4 with the ERROR.TYPE command. I can turn the 4 into a 0, but then when the number is not a 4, I get #N/A. Is there any way to get a 0 off of the pivot table if an employee name does not show up? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
View Pivot Table Source data as a Data Table | Excel Discussion (Misc queries) | |||
Lookup data in a variable table & retrieve data from a pivot table | Excel Worksheet Functions | |||
Filter lines containing pivot table and non pivot table data | Excel Worksheet Functions | |||
Pivot Table - Use Other Pivot Table as Data Source | Excel Discussion (Misc queries) | |||
How do I sort pivot table data outside a pivot table | Excel Worksheet Functions |