Cumulative Filter

[#1]

Hi,

This is the situation: I have a month filter which I want to work cumulatively to make some calculations.

Example: If have select the month "May" on the filter, the result I want to see is the whole selections of every month up to "May", that means "Jan","Feb","Mar","Apr","May".

Is there any possibility to make that?

Thank you for your attention

[jagan · Accepted solution]

HI,

Use the following expression

=Sum({<MonthFieldName=, DateFieldName={'>=$(=YearStart(Max(DateFieldName)))<=$(=Max(DateFieldName))'}>} Sales)

Regards,

Jagan.

[#3]

Thank you very much for your help