YTD in Custom Analytic Query (S4HANA Cloud)

[former_member717250]

Hi Everyone.

I'm developing a custom analytical query in s4hana cloud yo create a sac embedded analytic report.

I have my period range in columns and the ratio from a standard view. But I need to create the YTD measure. So I find how to create a calculated measure,

but I have no idea about the formula.

could you please help me?

Or the way I could get the YTD in my report?

For now it looks like this:

Sorry for my question I'm a SAC consultant not S4.

Thanks in advance. Hope someone can help me.

[JulianoRomanato]

Hello dlgp_dittasap.

How are you? I have excluded the Tag "SAP S/4HANA Cloud" and included the Tag "SAP S/4HANA Cloud Extensibility" for this question, as Custom CDS Views are related to Extensibility.

Regards.

Juliano Romanato.

[AngelaDai · Accepted solution]

Hello Diego Luis Guillen Paz,

You could have a try to create measures based on user input filter for field like fiscal year and period to see if it could fulfill your requirements.

Best regards,

Angela