Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
HI,
Use the following expression
=Sum({<MonthFieldName=, DateFieldName={'>=$(=YearStart(Max(DateFieldName)))<=$(=Max(DateFieldName))'}>} Sales)
Regards,
Jagan.
HI,
Use the following expression
=Sum({<MonthFieldName=, DateFieldName={'>=$(=YearStart(Max(DateFieldName)))<=$(=Max(DateFieldName))'}>} Sales)
Regards,
Jagan.
Thank you very much for your help