Pivot Table Data - Troubleshoot needed

A

aly1cat

Hi there, I had inherited a table summary which runs of a pivot table.
However for some reason I am getting "refs" messages which obviousl
means an error of some sort and having difficulties finding out wha
the error is?
can you help at all...if so, I can post the spreadsheet under separat
cover to look at?
But basically the formula is

"=GETPIVOTDATA("Count",'June 27 AP Status'!$A$6,"Objectiv
.","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 i
no data to get report back with a zero.

Can you help me?
 
D

Debra Dalgleish

As answered in microsoft.public.excel.misc:

You can use the ISERROR function to test the result. For example:

=IF(ISERROR(GETPIVOTDATA("Count",$A$6)),0,GETPIVOTDATA("Count",$A$6))
 

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

Pivot Table with Data Model Connection - getpivotdata reference issue 0
Pivot Table with Data Model Connection - getpivotdata #REF error 0
Multiple Tables and Multiple Pivot Tables Help 0
GETPIVOTDATA and (blank) 0
Pivot table report invalid 0
GETPIVOTDATA and Date-type field (Excel 2007) 0
Pivot Table Data - Troubleshoot needed 4
getpivotdata custom subtotal cell reference 3

Top