How to Show future months of current year in the Report.

We can show the future dates data on the view using Date Functions in Calculated field as below.

1) Create a calculated field as below image.

2) Now place the Order date, Calculated field on to the view.

4) Now reports shows Future Months Sales only. And shows the null for rest of the months.

5) Drag the calculated field on to filter shelf then select "Sum" then select "Special" tab. then select "Non null values" option.