GETPIVOTDATA - add multiple items in one item field

Hi everyone,

I would like some help to add multiple items in one item field. Specifically I need to add multiple months in my formula below. Right now I'm only able to add one month (in this example April), but I would like to be able to add May, June, July and so on.

=SUM(GETPIVOTDATA("[Measures].[SalesInvoicedTotal_DeliveredQty_ConsumerUnit_Ltr]";'Pivot table'!$A$10;"[Time].[Calendar Year]";"[Time].[Calendar Year].[All].[2022]";"[Products].[Item Group]";"[Products].[Item Group].[All].[Product1]";"[Time].[Month]";"[Time].[Month].[All].[April]"))

I don't know if it could be done with an array. If so I'm not sure how to.

Hi

use the bracket and a sum in front:

Please Login or Register  to view this content.

good luck

Thank you Rorya.
I tried with an array, but couldn't manage to do it the right way. But your solution works perfectly.

Thanks again.