YTD Calculation in SAC Excel Add in Using GETDATA()

[Hussha]

We want to calculate YTD AMOUNT in SAC Excel ADD in.

Currently Excel add is not supporting multiple selection is , is there any workaround?

SAP.GetData("DS_1","YEAR","2024", "Mnth","01,02,03,04,05,06.07")

We are using this for a connection to SAP Analytics Cloud (SAC),

[StevenUK]

I have solved this by having multiple data sources. DS_1 through to DS_12, using the master filter in the data source so that DS_1 = Jan, DS_2 = Jan+ Feb etc. 

Providing you do not reference the month in the Sap.Getdata formula this appears to work well, a simple lookup within the getdata formula to different data sources dependant on the date selected in your workbook works well.