Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table Data - Troubleshoot needed
-------------------------------------------------------------------------------- Hi there, I had inherited a table summary which runs of a pivot table. However for some reason I am getting "refs" messages which obviously means an error of some sort and having difficulties finding out what the error is? can you help at all...if so, I can post the spreadsheet under separate cover to look at? But basically the formula is "=GETPIVOTDATA("Count",'June 27 AP Status'!$A$6,"Objective .","002","Objective Title","Data Backup and Data Recovery","Sub OC","CMP2") What I want the formula to report is to get the data but if is there is no data to get report back with a zero. Can you help me?? -- aly1cat ------------------------------------------------------------------------ aly1cat's Profile: http://www.excelforum.com/member.php...fo&userid=4560 View this thread: http://www.excelforum.com/showthread...hreadid=556425 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table Data - Troubleshoot needed
You can use the ISERROR function to test the result. For example:
=IF(ISERROR(GETPIVOTDATA("Count",$A$6)),0,GETPIVOT DATA("Count",$A$6)) aly1cat wrote: -------------------------------------------------------------------------------- Hi there, I had inherited a table summary which runs of a pivot table. However for some reason I am getting "refs" messages which obviously means an error of some sort and having difficulties finding out what the error is? can you help at all...if so, I can post the spreadsheet under separate cover to look at? But basically the formula is "=GETPIVOTDATA("Count",'June 27 AP Status'!$A$6,"Objective ","002","Objective Title","Data Backup and Data Recovery","Sub OC","CMP2") What I want the formula to report is to get the data but if is there is no data to get report back with a zero. Can you help me?? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date formatting on a Pivot Chart's Data Table | Charts and Charting in Excel | |||
external import of multiple worksheet data & create pivot table | Excel Worksheet Functions | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
Pivot table Data refresh | Excel Worksheet Functions | |||
Pivot Table - max rows allowed in data range | Excel Discussion (Misc queries) |