Skip to main content
Question

best workaround to get all linked records to display in pivot table?

  • Nov 20, 2026 6:55 PM UTC
  • 0 replies
  • 1 view

Forum|alt.badge.img+6

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:

  1. Students
  2. Attendance encounters
  3. 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).