Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
=sum({<
Year={'$(=Max(Year))'}
,Datefield={">=$(=Date(Monthstart(Max(Datefield))))<=$(=Date(Max(Datefield)))"}
>}EX_Data )
Hi,
And if you just try with :
sum({<Year={2022}>} EX_Data )
=sum({<
Year={'$(=Max(Year))'}
,Datefield={">=$(=Date(Monthstart(Max(Datefield))))<=$(=Date(Max(Datefield)))"}
>}EX_Data )