I will create a calculated field using date diff. It will give me the difference in months from today. Then I will filter the sheet for values less than 12.
datediff('month', [Order Date],[today])
Thank you Arvind. But, my requirement for Feb '18 is to pull data only for Jan' 18. (I have to pull only one month in 2018).
I will have one more data item and filter it for TRUE. I will have two filters now.
IF(MONTH([today -1]) = 1) then TRUE
elseif YEAR([today -1]) = YEAR([Order Date]) then TRUE