Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table Data - Troubleshoot needed
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 |
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) |