Count Table of Display sizes by Location

Yes. The reason is that further action needs to be done on this count that will lead to deployment.

So there are two steps.  making the table and maintaining the table.

The making the table is easy but there is a trick.  You need to create a key field for the table in the format.

Building Name-Department Name-Display Size.

So  you create the table and make a field with that long name as the Key field and populate it by Creating a field in the details table with the formula


List("-", [Building Name], [Department], [Display Size])

 and then making a summary report like you already did, except do it on that formula field.  The use the more .. button to copy to another table.

 The create a field called [Building Name-Department Name-Display Size exists?] as a formula checkbox field with a formula of true.

Then build a relationship back to the details table and look up that field.
[Building Name-Department Name-Display Size exists?]

Lastly fire an Automation that says when a detail record is created and 
[Building Name-Department Name-Display Size exists?] = not checked, then add a record to the Summary table and populate that Key field with the value in the formula field.

You will then be able to get your total counts from a summary field on the  Relationship and they will be self maintaining.

Was able to follow along until copying summary report data to another Table. I am confused with steps after that. Which table should the [exists?] field be created in - details table or new table? How do I check if that data exists in the new table?