YTD calculation not working

[#1]

Hi,

I am working on a YTD calculation where I need to calculate it based on the year and month selected by the user.

Though I could get it working by year, it is not working when user select a particular month. This is the expression I am using:

sum({$<Year = {$(=only(Year))}, Month = {"<=$(=max(Month))"}>}SALES_QTY)

Thanks

[brenner_martina]

Hi, arch25

you have to enter a varable:

varMonth: =Max(Month)

and the set analysis looks like this:

Sum({$<Year= {$(=only(Year))}, Month= {"<=$(varMonth)"}>} SALES_QTY)

[#3]

Hi,

I tried this but it does not resolve the problem.

Thanks

[brenner_martina]

do you have an example?

[#5]

Hi Martina,

Here's the example file.

Thanks

Archana