Year to date question!
Hi Experts -
I need a report like below:
Employee Aug Sales YTD Sales
Jon 5000 60000
Tom 2000 70000
I was reading through the forum and I see that I have to use customer exit for that. I'm using 0CALMONTH for my variable.
But I also saw that I can avoid the customer exit and use the properties on the key figure.
But the figures are not correct.
I read here that in the properties Calculations -> Calculate as Single Value-> choose Standard Value. But I don't have any option for 'Standard Value' .
Can someone please share his/her thoughts on this? Thanks a lot!
I believe you have two options. One where the user enter the month they wish to see and the YTD range. It's a little messy that way.
The other option is with a Customer Exit on 0calmonth. So you have the 0calmonth in a selection with a variable that the user enters the month they want to view on the report. And then another selection with a customer exit on 0calmonth which derives the YTD range based on the input of the user.