Cumulative of months of the financial year (Apirl-March)

[PK422]

I have sum of sales based every of month for 2years now I want cumulative of starting of the year to current selected month year

Ex: if i select August 2022 then it show me April2022+May2022+June2022+July 2022+August 2022

I have column like start date , end date,monthyear (mmm-Yy),sum(sales)

[maheshkuttappa]

Try this, There are other ways to handle this also. 

Sum({<monthyear ={">=$(=YearStart(FirstSortedValue(distinct monthyear,monthyear),0,4)) <=$(=IF(GetSelectedCount(monthyear)=0, YearEnd(FirstSortedValue(distinct monthyear,monthyear)),Max(monthyear)))"}>}Sales)

[maheshkuttappa]

@PK422 were you able to solve this using the above expression?

[PK422]

Its working but i used different one

any way Thank you!!