I'm trying to create a filter that will:
- Look at an existing column called "Inv Period" that contains various dates
- Sort this data using the logic of:
- Current Month - filter will recognize the current month in the Inv Period column (which is not always the month that the process will be run in, rather the most recent month's data in the column) and will filter on this
- Prior Month - filter will recognize the previous month in the Inv Period column and filter on this
- Current Month and Prior Month - combo of the two above
- Future Month - filter will recognize future dates in the Inv Period column and filter on these
See attached for a loose visualization.