Hi Community,
i need your help with folowing requirements:
I need a set analysis statement for YTD Calculation.
I have two date fields:
Datefield 1 Value
sep 100
oct 200
nov 300
dec 400
Datefield2
sep
oct
nov
dec
based on the selection in Datefield 2 the ytd should be calculated until the selected month datefield 2.
So if I select NOV in datefield the YTD should run from sep to nov. If is select oct the YTD should run from sep to oct.
But the set analysis statement needs to build with the Datefield1 as this contains also the values.
Basically we need to pass the month of the datefield2 to the set analysis statement.
Thanks for your help.
Regards
Fatih