Step1:

Create parameters 1.Start date 2. End Date 3. Filter ON/OFF

Start Date

Untitled.png

End Date

End Date.png

 

Filter ON/OFF

filter.png

 

Step2:

Create Calculation [Date Range]

IF [Filter ON/OFF]="OFF" THEN date([Order Date]) ELSEIF date([Order Date])<[End date] AND date([Order Date])>[Start date] THEN date([Order Date]) END

 

Step3:

Drag this new calculation [Date Range] into filter and select all

 

Step4:

Show parameter start date, end date

 

Step5:

Drag date into row and select days, month etc.