How to write set analysis for sales 1st March to 2nd April? please explain?

[Anonymous]

How to write set analysis for sales  1st March to 2nd April? please explain?

[mdmukramali · Accepted solution]

Hi,

You can use something like this.

but make sure Date format same as Date format in the expression ( DD/MM/YYYY)

=Sum({<Date={"$(= '>=' & '01/03/2018' & '<=' & '02/04/2018')"}>} Sales)

Thanks,

Mohammed Mukram

[Anonymous]

Thank you