Dynamic selection

[Maddineni_S]

Hello Members,

I have written an expression, by default which should give letest month data "sum({<Year={2022},Month={'May'}>} EX_Data )" but when i select another month from filter it should give the selected month value. can some one guide me to write the expression.

thanks in advance. 

[sergio0592]

Hi, 

And if you just try with :

sum({<Year={2022}>} EX_Data )

[vinieme12 · Accepted solution]

• If no selections are made: This will show latest month and latest year
• If a month is selected and not year: This will show selected Month and latest year
• if year is selected and not month: This will show latest month for selected year
• if year and month is selected: This will show selected month and selected year

=sum({<
Year={'$(=Max(Year))'}
,Datefield={">=$(=Date(Monthstart(Max(Datefield))))<=$(=Date(Max(Datefield)))"}
>}EX_Data )