Does anyone know how to get the YTD values in SAC Addin for excel?

[kocomandi]

I just started to explore the SAP Analytics Cloud add-in for Excel and I was wondering how to get the YTD numbers for P&L. I have tried to use the SAP GET DATA formula but have been unsuccessful.

Your help will the greatly appreciated.

Thanks 

[jmoon]

I had to create calculated measures in the modeler so that can be reference in the GetData statement. You will always need a time period in the same rows/columns where you use this new measure.

LOOKUP([GC], [d/Time] = ToPeriod("Year")) can also have a QTD just replace Year with Quarter in a new measure.

GC is my group currency value, [d/Time] is my Time dimension type

[sathyapachipala]

Hi,

Check this link below.

https://community.sap.com/t5/technology-blogs-by-members/mtd-ytd-ytg-yeartogo-calculations-in-sap-an...

[William_Yu1]

Before restricted measure is supported in SAC add-in, the only option to have YTD is by levarge formula like YTD from calculated measure/account in model.