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?