# Rollup on different items without having a separate table
**URL:** https://community.glideapps.com/t/rollup-on-different-items-without-having-a-separate-table/69503
**Category:** Ask for Help
**Created:** [January 12, 2024, 1:13pm UTC](https://community.glideapps.com/t/rollup-on-different-items-without-having-a-separate-table/69503 "2024-01-12T13:13:04Z")
**Posts on this page:** 5
**Page:** 1
### Author:  [@Joe\_Gabriele](https://community.glideapps.com/u/Joe_Gabriele)
#### Post date: [January 12, 2024, 1:13pm UTC](https://community.glideapps.com/t/rollup-on-different-items-without-having-a-separate-table/69503/1 "2024-01-12T13:13:04Z")
Situation:
User adds a receipt to a Receipts Table
AI pulls waiter from receipt
User rates the waiter
I do not have a separate table for each waiter
I do have a Vendor table which is related to the Receipts Table
On the Vendor Table, I created a Lookup to find all waiters referenced in the Receipt Table and then used a Unique elements to remove duplicate waiters.
Through a multi relation between all the unique waiters and the Receipts table I can find each waiter and all their “receipts” / ratings.
What I’d like to figure out is if its possible to get each unique waiter’s average rating though a Rollup and display them in some sort of an Array. Ultimately I would like to provide each waiter’s rating. I did a rollup over the multi-relation, but just got the average of all the waiters and their ratings combined, not their individual ratings.
This would be much easier / possible if I had a Waiter table, but its not a huge feature of the app, so I would like to avoid consuming lots of rows just for this one thing.
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [January 12, 2024, 1:25pm UTC](https://community.glideapps.com/t/rollup-on-different-items-without-having-a-separate-table/69503/2 "2024-01-12T13:25:47Z")
I would do that in the receipts table. Create a relation linking the waiter column to itself. Then create a Rollup that uses the relation to calculate the average for each waiter.
---
### Author:  [@Joe\_Gabriele](https://community.glideapps.com/u/Joe_Gabriele)
#### Post date: [January 12, 2024, 1:28pm UTC](https://community.glideapps.com/t/rollup-on-different-items-without-having-a-separate-table/69503/3 "2024-01-12T13:28:15Z")
Very nice! So their average rating will constantly be updated in the Receipt Table and I can just pull from that. Nice! Thank you
Any recommendation on how to display each waiter and their average rating in a list after removing duplicates?
Actually I found a prior answer that solves the above: [Is there a way to filter duplicates from an inline list? - #14 by Jeff\_Hager](https://community.glideapps.com/t/is-there-a-way-to-filter-duplicates-from-an-inline-list/21270/14)
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [January 12, 2024, 1:48pm UTC](https://community.glideapps.com/t/rollup-on-different-items-without-having-a-separate-table/69503/4 "2024-01-12T13:48:54Z")
Yep, that’s exactly what I would have suggested.
---
### Author:  [@system](https://community.glideapps.com/u/system)
#### Post date: [January 19, 2024, 1:49pm UTC](https://community.glideapps.com/t/rollup-on-different-items-without-having-a-separate-table/69503/5 "2024-01-19T13:49:18Z")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.