I am trying to use the getpivotdata formula and am stubbling on some
problems with the formula I am using.
=GETPIVOTDATA("Count",Sheet4!$A$6,"Objective ","001","Objective
Title","External Service Management","Sub OC","CMP")
I am basically trying to get data (for a summary sheet) from a pivot
table, however the pivot table does not display a heading which has no
data. So if my formula was asking for the pivot table to gather data
from a column titled Ext Service Management it comes back as a "REF" as
the pivot table is not showing any for that particular title as there
are none.
Question is how can I get either:
1. the pivot table to show the title even if no data is there
2. how I can change the formula to return a nil value is there is no
title and no data?
--
aly1cat
------------------------------------------------------------------------
aly1cat's Profile:
http://www.excelforum.com/member.php...fo&userid=4560
View this thread:
http://www.excelforum.com/showthread...hreadid=567901