# Grouping and Summarizing Unique Values In a Table

**URL:** <https://community.glideapps.com/t/grouping-and-summarizing-unique-values-in-a-table/79874>\
**Category:** Ask for Help\
**Created:** [February 7, 2025, 11:21am UTC](https://community.glideapps.com/t/grouping-and-summarizing-unique-values-in-a-table/79874 "2025-02-07T11:21:01Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![rgutierrez](https://avatars.discourse-cdn.com/v4/letter/r/59ef9b/32.png) [@rgutierrez](https://community.glideapps.com/u/rgutierrez)\
**Post date:** [February 7, 2025, 11:21am UTC](https://community.glideapps.com/t/grouping-and-summarizing-unique-values-in-a-table/79874/1 "2025-02-07T11:21:01Z")

</div>

I’m building an internal application and we’re running into an issue regarding grouping and summarizing data within a table.

Goal: Per the image below we need to group unqiue values and then sum their corresponding data values from this table below without creating more tables. An Example:

We need to display Lamar as a single Lamar with it’s sum of Impressions, Or Display Chicago as a single Chicago with it’s sum of media cost.

Lamar - (Sum of Impressions across the entire table)  
Adxcelerant - (Sum of Impressions across the entire table)

 ![Screenshot 2025-02-07 at 12.14.14 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/b/0b5f1b790fcf5944112800dfb66030e958d14dc7.jpeg)

We don’t want to create another table since the data changes daily and new publishers or cities are added.

Thanks in advance for your help!

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [February 7, 2025, 11:34am UTC](https://community.glideapps.com/t/grouping-and-summarizing-unique-values-in-a-table/79874/2 "2025-02-07T11:34:21Z")

</div>

- Create a multiple relation column that matches the Publisher with itself.
- Create a rollup column, target it at the multiple relation column, and select Sum-\>Impressions (or sum-\>Media Costs)

To create something you can use as a filter:

- Use a single value column to take the first RowID from the multiple relation
- Create an if-then-else column and apply the following condition:  
– If RowID is single value RowID, then `true`
- Use the if-then-else column as a collection filter (only show rows where it is checked)

---

<div class="post-metadata">

**Author:** ![rgutierrez](https://avatars.discourse-cdn.com/v4/letter/r/59ef9b/32.png) [@rgutierrez](https://community.glideapps.com/u/rgutierrez)\
**Post date:** [February 7, 2025, 11:40am UTC](https://community.glideapps.com/t/grouping-and-summarizing-unique-values-in-a-table/79874/3 "2025-02-07T11:40:55Z")

</div>

Hey Darren! Thanks for your quick resonse. I applied it and it works perfectly!

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [February 14, 2025, 11:41am UTC](https://community.glideapps.com/t/grouping-and-summarizing-unique-values-in-a-table/79874/4 "2025-02-14T11:41:17Z")

</div>

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.