Use variables to calculate sales between two dates. Start date will be your Month Start of fiscal year and End date will be the last date of selected month. You can use both these variables to get sales between selected period
| set | st_date= | date(monthstart(FirstMonthOfFiscalYear),'YYYY-MM-DD'); |
| set | en_date= | date(monthend(Max(SelectedMonthYear)),'YYYY-MM-DD'); |
= sum({<bill_date={">=$(=st_date) <=$(=en_date)"}>}sales)
