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.
Bookmarks