I’ve been trying to set up an Event Table, with a certain category attached to it, and I’d like to know how many Events of each category are upcoming or in the past.
Current Table situation is that I have an Event Tab and a Category Tab.
The Event Tab has a column “category” which links to the Category Tab.
So I am able to count the number of categories in total, but how can I limit the Events that are shown in the Category Tab to a certain criteria?
If I try to turn on “limit to view” in the “event” column, it does nothing.
Maybe someone has an idea for a workaround.