sum last date in selected months

[davinfrost]

hi guys, 

i want to ask , how to sum a specific date on every month ,

in this case i want sum every last date on every month,

for example, if i filtered january,february and march, that means it will sum on 01/31 , 02/28, 03/31.

for now i only use this condition

sum(
{<
FLAG_TRANS={'Outstanding'},
Year={'$(=max(Year))'}
>}
OOWING)

any help? 

thanks

[namratam3]

=if(getselectedcount(month)>0,sum({<year={"$(=max(year))"},date={"$(=monthend(date))"}>}OOWING),sum({<year={"$(=max(year))"}>}OOWING))

[andrey_krylov · Accepted solution]

sum(

{<
Date={"=If(Date=Text(Date(MonthEnd(Date))), Date)"},
Year={'$(=max(Year))'}
>}
OOWING)

[davinfrost]

cool, thanks mate