getpivotdata having multiple items

Hi

I am looking to use the getpivotdata formula to return a value for
multiple items. ie partner_id



GETPIVOTDATA("IMMEDIATES", IMMEDIATES_newptr_ptrs!A6, "DATE",
DYNAMIC_SHEET!C$1, "PARTNER_ID", DYNAMIC_SHEET!B2)

I would like this to be dynamic as i would like to return a value for
immediates of partner_id 6 or 9 or 10. so instead of using
GETPIVOTDATA("IMMEDIATES", IMMEDIATES_newptr_ptrs!A6, "DATE",
DYNAMIC_SHEET!C$1, "PARTNER_ID", DYNAMIC_SHEET!B2) +
GETPIVOTDATA("IMMEDIATES", IMMEDIATES_newptr_ptrs!A6, "DATE",
DYNAMIC_SHEET!C$1, "PARTNER_ID", DYNAMIC_SHEET!c2) +
GETPIVOTDATA("IMMEDIATES", IMMEDIATES_newptr_ptrs!A6, "DATE",
DYNAMIC_SHEET!C$1, "PARTNER_ID", DYNAMIC_SHEET!d2)
where b2=6, c2=9 and d2=10 i would like it in one get pivot formula.

Thanks any help is much appreciated

You could add a field to the source data, to identify the partners you
want to total. Add that field to the pivot table, and use the
GetPivotData formula to return the total for the group.

RoboStat wrote:
> Hi
>
> I am looking to use the getpivotdata formula to return a value for
> multiple items. ie partner_id
>
>
>
> GETPIVOTDATA("IMMEDIATES", IMMEDIATES_newptr_ptrs!A6, "DATE",
> DYNAMIC_SHEET!C$1, "PARTNER_ID", DYNAMIC_SHEET!B2)
>
> I would like this to be dynamic as i would like to return a value for
> immediates of partner_id 6 or 9 or 10. so instead of using
> GETPIVOTDATA("IMMEDIATES", IMMEDIATES_newptr_ptrs!A6, "DATE",
> DYNAMIC_SHEET!C$1, "PARTNER_ID", DYNAMIC_SHEET!B2) +
> GETPIVOTDATA("IMMEDIATES", IMMEDIATES_newptr_ptrs!A6, "DATE",
> DYNAMIC_SHEET!C$1, "PARTNER_ID", DYNAMIC_SHEET!c2) +
> GETPIVOTDATA("IMMEDIATES", IMMEDIATES_newptr_ptrs!A6, "DATE",
> DYNAMIC_SHEET!C$1, "PARTNER_ID", DYNAMIC_SHEET!d2)
> where b2=6, c2=9 and d2=10 i would like it in one get pivot formula.
>
> Thanks any help is much appreciated
>


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html