Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
On my filter pane, I want to show all the months except the current calendar month. In the below example, I want to omit the month of June 2020 and when we are in July, I want to exclude July and so and so forth.
I want the user to be able to filter on all the older months. This filter is linked to a data table and it goes back to April 2019.
I need to exclude the current month from my month filter pane? Is there a way to this?
You can create a calculated field for this purpose.
Rather than using the field Month, in the filter pane use an expression like:
=Aggr(Only({<Month=-{'$(=Month(Today()))'}>}Month), Month)
Please help
I do not know your data. You don't appear to have a field called Month.