cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

YTD/MTD/YOY calculated Measures in SAP analytics cloud

Deb_D
Participant
0 Kudos
486

Hi, 
I struggle creating two simple DYNAMIC report using YTD/MTD calculated Measures in SAP analytics cloud. or any other way. (I also don't get easy results with restricted calculation)

that would be the result - how should I do that?

Deb_D_0-1730035758027.png

also, I would like to be able to compare 2 same period different year (jan-aug for instance) without using this filter. to create a YOY based on my last current year month - is that possible?

Deb_D_1-1730036038154.png

when I try with the measure formula I can't get any result in YOY and for YTD it requires working monthly which I don't want. 

Deb_D_2-1730036314547.png

 

 

Thank you!


 

Accepted Solutions (0)

Answers (1)

Answers (1)

Deb_D
Participant
0 Kudos

Hi @William_Yu1 
How are you doing?

the problem is visual, I don't want to create a monthly level report, and if I let the measures on a high level it gives me nothing - and without the date dimension i just can see that something is "hidden". by the way i couldn't see the YOY formula at all (I have "zeros" only on the monthly view.)
maybe I just don't know how to handle those calculated measures
thank you

Deb_D_0-1730098706946.png

 

William_Yu1
Product and Topic Expert
Product and Topic Expert
0 Kudos
In your second screenshot, what do you have if you put a table fitler to a month?
Deb_D
Participant
0 Kudos
YOY would be zero on 2024. YMD and MTD would work - but it makes things not friendly and not clear.