GETPIVOTDATA function

[mark]

Hello.

I have a GetPivotData function, as such:

=GETPIVOTDATA("PROPOSED_AMOUNT",$A$1,"ITEM_NUMBER","00424400-01","PROMISED_MONTH","2008_08")


But, I don't want to use a hardcoded ITEM_NUMBER and PROMISED_MONTH . I
want to use a list of rows for the ITEM_NUMBER and a set of column headers
for the PROMISED_MONTH input.

That part's easy enough, but the input list of item numbers is not the same
list, in total, as the list of items in the Pivot Table. Some of the items
in the list are in the Pivot Table, and some are not.

For the items that are in the Pivot Table, I get the proper number... for
the items in the list that are not in the Pivot Table, it returns #REF.

I could probably write my own function to return 0 or " " when the item is
not in the Pivot Table, but is that how GETPIVOTDATA is supposed to work?

Thanks,
Mark

 

[Roger Govier]

Hi Mark

You have to use
=IF(ISERROR(yourGPDformula),"",yourGPDformula)

 

[mark]

Thanks, Roger... tha'ts what I came up with later last night.

I've done that for years with VLOOKUPS, though it tends to run slowly if you
get too many... then I work around it.

But anyway, yeah, that's what I came up with later... thought I'd check back
to see if anyone had something more that I hadn't thought of or didn't know
about.

Thanks!