YTD Calculation in SAC Excel Add in Using GETDATA()

[ushadesu]

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. 

[daoa910716]

You could try creating a calculated measure specifically for YTD. They recently implemented the YTD and QTD formulas in the calculated measure creation

 

.

[N1kh1l]

@ushadesu 

GETDATA() only supports single member for each dimension member. You cannot pass a range or multiple members. If your requirement is to calculate YTD, its better you create a  calculated measure in the model itself and then use that to report. You would need a calculated measure for each account/measure whose YTD you need. If you want to do the excel based calculation you would have to get data for each month using GETDATA() ands then sum it based on conditions may be in a SUMIFS.

Currently there is no option to create a  calculated measure inn Excel Add-in.

Nikhil