YTD set analysis with Day selection

[#1]

Hi guys!

I have a question regarding YTD using set analysis. I have this expression:

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

but I need to consider Day selection too. How can I do that?

Hope that you can help me with my problem.. Thanks in advance!

Lester

[martin59 · Accepted solution]

Hi Lester,

You can try this :

sum({<Date={">=$(=date(YearStart(Max(Date)))) <=$(=Max(Date))"}, Year=, Month=, Day=>} Sales)

[#3]

Thanks Martin!

I can also use your set analysis to my MTD just by replacing YearStart to MonthStart, and this also gives me some idea on my other expressions!

tyvm!

Regards,

Lester