According to date day selection it will display the Month start to selected date value.

[Ramu_i]

Hi All,

I have month wise reports are there. Day filter is there.

Requirement is:

Month     Total      Required OutPut

Jan            200         120

Feb            250         135

Mar          400           200

If select the day , Mar-14-2023, Every month it will display the Month 1 to selected date value.

Jan-1-2023 to Jan-14-2023, feb-1-2023 to Feb-14-2023,...

If select the Apr-20-2023, It will display the Every month first to Every month 20th data will display.

Thanks Advance.

Ram

[rubenmarin · Accepted solution]

Hi, if you have a date field you can create a day field from that date: Day(Date) as Day. Also a month field: Month(Date) as Month

And apply set analysis to ignore th selctions on date and use gay and month fields, like:

Sum({<Month={"<=$(=Month(Max(Date)))"},Day={"<=$(=Day(Max(Date)))"},Date>} Value)

[Ramu_i]

Hi Rubenmarin,

Thanks for solution.

Thanks & Regards,'Ram