Please see the attached
it returns this in text format
and this in bars
this is a t/f filter that will reset every month
place it on the filter shelf and set to true
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
month year .twbx 2.4 MB
Is your problem solved ? Did you get answer to your question?
Thanks a lot Jim it's working fine with this formula MONTH([Order Date])<MONTH(TODAY())
Once again thanks a lot for your help.
Thanks for your reply using window calculations it's working but every month we need to change manually. That's not my requirement. But using of Jim formula (month([Order Date])<MONTH(today())) I'm able to do this.
Once again thanks for your responds.