# Group by relation or lookup column
**URL:** https://community.glideapps.com/t/group-by-relation-or-lookup-column/26563
**Category:** Ask for Help
**Created:** [May 8, 2021, 11:50pm UTC](https://community.glideapps.com/t/group-by-relation-or-lookup-column/26563 "2021-05-08T23:50:20Z")
**Posts on this page:** 5
**Page:** 1
### Author:  [@AKnewbee](https://community.glideapps.com/u/AKnewbee)
#### Post date: [May 8, 2021, 11:50pm UTC](https://community.glideapps.com/t/group-by-relation-or-lookup-column/26563/1 "2021-05-08T23:50:21Z")
When using “Group by” option for my list I cannot see the relation or lookup column I have created in the data sheet. (I am using glide option and not an actual google sheet).
just started working with it today.
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [May 9, 2021, 1:36am UTC](https://community.glideapps.com/t/group-by-relation-or-lookup-column/26563/2 "2021-05-09T01:36:51Z")
What do you mean by “cannot see the relation or lookup column”? Can you attach some screenshots?
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [May 9, 2021, 3:24am UTC](https://community.glideapps.com/t/group-by-relation-or-lookup-column/26563/3 "2021-05-09T03:24:31Z")
A relation is a row or series of rows, so there wouldn’t be any specific column to group by.
You can only group by a lookup column if it’s a single lookup derived from a single relation. If it’s a multiple (array) lookup derived from a multiple relation, then it could potentially hold hundreds or thousands of values, so it would be impossible to create a single group based on multiple values.
If you want to see a Lookup column as an option for grouping, then it needs to be derived from a single relation.
---
### Author:  [@AKnewbee](https://community.glideapps.com/u/AKnewbee)
#### Post date: [May 9, 2021, 8:10pm UTC](https://community.glideapps.com/t/group-by-relation-or-lookup-column/26563/4 "2021-05-09T20:10:04Z")
yep that makes sense, I will try with single relation instead.
---
### Author:  [@NoCodeAndy](https://community.glideapps.com/u/NoCodeAndy)
#### Post date: [January 17, 2024, 4:52pm UTC](https://community.glideapps.com/t/group-by-relation-or-lookup-column/26563/5 "2024-01-17T16:52:17Z")