R
RoboStat
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
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