1 of 1 people found this helpful
Create two calculated fields as below.
Remove your existing field and place these fields to the filters shelf.
Hope this helps.
Works like a charm! Thanks alot Tushar!
Derek... you're welcome