relative date slicer exclusions
The 'relative date filtering' option in the 'Filter Type' drop-down is a great tool, but it doesn't contain the ability to exclude dates.
It would be great if I could select "Show items when the value: is NOT in the last day, month, or year" rather than only being able to select inclusive dates.
This is specifically for the use-case of looking at rolling Same Store Sales numbers. I need to be able to exclude customers whose first sales dates are in the last 12 months. A Relative date filtering selection for this would look like "Show items when the value: is not in the last 12 months".
Thanks for reading!
Not only dates!, integer also
John Palmer commented
I have a similar requirement. I need to show a report with items due in 30, 60, 90 day windows. I need to be able to show "is in the next 60 days AND is NOT in the next 30 days".