I’ve made a workaround and want to get thoughts on whether there are better ways to do this.
Goal: display all records linked to a certain record in a pivot table.
Setup:
I’m working with four linked tables:
- Students
- Attendance encounters
- Classes
The pivot table pulls from the Attendance Encounters table and is broken down by month.
Teachers asked for the pivot table to display all students currently enrolled in the class even if they haven’t attended in that month.
Here is what the pivot table looks like:

The last column in each month is a placeholder to ensure that every student shows up in the pivot table, even those with no attendance.
My question is: is there any better/cleaner way to do this?
I can share a demo AT that shows the tables & how they are related (just doesn’t show the pivot tables since it’s on a free workspace).
