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

getpivotdata having multiple items
 

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