YearMonth Selections

[SATISH6]

HI Team,

We created one filter panel keep there always one selection,

Then when i selected Month Year like (Apr-2024) earlier months like like

Jan-2024 to Apr-2024. Sum({<Period={"<=202404"}>}Sales). This logic only working current selections.

Again when i selected Month Year like (Aug-2024) earlier months like like Jan-2024 to Aug-2024. Sum({<Period={"<=202408"}>}Sales).  

Again we will selected 

[rubenmarin]

Hello, your question it's not clear to me. What is not working? You can use a translator to give a more detailed explanation.

[PrashantSangle]

Try Sum({<date={">=date(yearstart(yourdatefield))<=date(yourdatefield)"}>}Sales)