While creating the Extracts, we can add filters. Click on "Add" in the filter's box then select the Date related field then define t he Filter. ( This Month)
Right-click the data source and choose Extract Data.
In the dialog box, optionally define one or more filters to limit how much data gets extracted.
I want to exclude the current month
(not to include only the current month )
u need to click on add filter on source level , one popup window will open in that click on add then you have to select column name and select what you want to filter and click on Exclude check box (that will not display in report) or u have to click on condition tab in that you should write condition based on your requirement.
might be this will help you.
1 of 1 people found this helpful
Best option is "Writing Custom SQL" then extract the data.
The following synyax may help you to get the all data apart form current Month and Future months.
Select * from [Sales$] where
year([Date])=year(today()) and month([Date]) <= month(today())-1
Thank you very much
that calculation helped