Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I want to show Sales by max date for each Month.
If my Max date is 15-06-2019. Then I want to show each month sales by this Day .
For Ex:
Jan Start Date should be 01-01-2019 and end date is 15-01-2019
Feb Start Date should be 01-02-2019 and end date is 15-02-2019
....
Jun Start Date should be 01-06-2019 and end date is 15-06-2019
Please help to acheive
create a day column from your date fields in your master calendar
and use an expression something like below
Sum({<Day={"<=$(=day(max(OrderDate)))"}>}Sales)