# Summary Table
**URL:** https://community.glideapps.com/t/summary-table/64970
**Category:** Ask for Help
**Created:** [August 13, 2023, 1:27pm UTC](https://community.glideapps.com/t/summary-table/64970 "2023-08-13T13:27:21Z")
**Posts on this page:** 7
**Page:** 1
### Author:  [@Mattthew](https://community.glideapps.com/u/Mattthew)
#### Post date: [August 13, 2023, 1:27pm UTC](https://community.glideapps.com/t/summary-table/64970/1 "2023-08-13T13:27:21Z")
I feel like this is going to be something I will be kicking myself about when it’s pointed out to me.
I need to generate a summary table, where similar items are combined and the sum is given.
The table should say Apple (once) and Qty 3, as seen in the graph.
FYI I will be filtering the data based on employee.
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [August 13, 2023, 1:49pm UTC](https://community.glideapps.com/t/summary-table/64970/2 "2023-08-13T13:49:31Z")
> [@Mattthew](#):
>
> FYI I will be filtering the data based on employee.
Wouldn’t this mean the total for Apples should be variable, depending on which employee you are filtering by? (eg. 2 for Jeff, 1 for John).
Anyway, essentially what you want to do is start by creating a query column including the filters that you need, and then do a rollup-\>count via the query.
Note that this won’t work if you are using the In App filtering with the Chart. To do it in a way that the table and chart match up, you’d need to create your own custom filter.
---
### Author:  [@Mattthew](https://community.glideapps.com/u/Mattthew)
#### Post date: [August 13, 2023, 10:41pm UTC](https://community.glideapps.com/t/summary-table/64970/3 "2023-08-13T22:41:35Z")
Thanks, Darren.
I must have had some misdirected Relations messing things up.
I was able to do as you suggested, both with a Relation and a Query.
Now I need to figure out the filters.
Thanks.
---
### Author:  [@Mattthew](https://community.glideapps.com/u/Mattthew)
#### Post date: [August 14, 2023, 1:30am UTC](https://community.glideapps.com/t/summary-table/64970/4 "2023-08-14T01:30:57Z")
@Darren_Murphy you were spot on.
The query gave me the columns I needed in the data editor, however, I’m getting duplication on the Data Grid because I can’t reference the Query on that.
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [August 14, 2023, 2:03am UTC](https://community.glideapps.com/t/summary-table/64970/5 "2023-08-14T02:03:30Z")
- Add a RowID column to your table, if it doesn’t already have one.
- Create a Single Value column, taking the first RowID from your Query column
- Create an if-then-else column:
– If Single Value RowID is RowID, then true
Now apply a filter to your Grid, only showing rows where the if-then-else column is checked.
---
### Author:  [@Mattthew](https://community.glideapps.com/u/Mattthew)
#### Post date: [August 14, 2023, 1:11pm UTC](https://community.glideapps.com/t/summary-table/64970/6 "2023-08-14T13:11:46Z")
Like a charm. Thanks!
Seems like a lot of inefficiencies to overcome not having a feature here or there.
---
### Author:  [@system](https://community.glideapps.com/u/system)
#### Post date: [August 21, 2023, 1:12pm UTC](https://community.glideapps.com/t/summary-table/64970/7 "2023-08-21T13:12:42Z")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.