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

Hi Mark

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

--
Regards
Roger Govier

"mark" wrote in message
...
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

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!

"Roger Govier" wrote:

Hi Mark

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

--
Regards
Roger Govier

"mark" wrote in message
...
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