Sep 13, 2023 05:05 AM
Hello,
I have Table of people and for eveybody I have registration month by number.
It looks like that: Name:Adam, Registered:9
Than I have second table with courses. For each course I have assigned that people. The cource has its own month.
For example: Yoga:Adam,Robert, Month:9
I would like to have new column, that will include only the people that was registered in the same month as the course.
The month is different for each course so I cannot use the filter function in rollup. Please help.
Sep 14, 2023 08:46 PM
Hello,
Are the people you have assigned in Table 2 records linked or just names?
Sep 14, 2023 10:40 PM
Yes, they are linked.
Sep 15, 2023 07:16 PM
I've had this same issue in the past so I made a mock table. Is this what you would want your 2 tables to look like?