# How can I group this data by department? Any idea?

**URL:** <https://community.glideapps.com/t/how-can-i-group-this-data-by-department-any-idea/54683>\
**Category:** Ask for Help\
**Created:** [November 22, 2022, 7:13am UTC](https://community.glideapps.com/t/how-can-i-group-this-data-by-department-any-idea/54683 "2022-11-22T07:13:36Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![agungmrf](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/agungmrf/32/50700_2.png) [@agungmrf](https://community.glideapps.com/u/agungmrf)\
**Post date:** [November 22, 2022, 7:13am UTC](https://community.glideapps.com/t/how-can-i-group-this-data-by-department-any-idea/54683/1 "2022-11-22T07:13:36Z")

</div>

![2022-11-22_134040](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/6/661104ade07d671f09cca1113d86b54f32ec6fa4.png)  
 ![2022-11-22_134118](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/1/01278a7e39cf54f15de3f0a84fbf5dca4e0c2086.png)

I plan to group departments, how do I do that? but i don’t have the solution to solve this problem. anyone can help me to solve this problem?

---

<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:** [November 22, 2022, 7:16am UTC](https://community.glideapps.com/t/how-can-i-group-this-data-by-department-any-idea/54683/2 "2022-11-22T07:16:49Z")

</div>

Add a Collection component to your screen, then under the component options you will find a setting for grouping the data.

 ![Screen Shot 2022-11-22 at 3.16.06 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/e/4e8dc0fb44c9438f5f05fa5c2c181a838312c610.png)

---

<div class="post-metadata">

**Author:** ![agungmrf](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/agungmrf/32/50700_2.png) [@agungmrf](https://community.glideapps.com/u/agungmrf)\
**Post date:** [November 22, 2022, 8:29am UTC](https://community.glideapps.com/t/how-can-i-group-this-data-by-department-any-idea/54683/3 "2022-11-22T08:29:31Z")

</div>

> [@Darren\_Murphy](#):
>
> Add a Collection component to your screen, then under the component options you will find a setting for grouping the data.

Thanks, but I want it to appear that the product folder is not duplicated. So every time an item is added to the product department/ product folder, the product folder is not created again? do you know it?

---

<div class="post-metadata">

**Author:** ![agungmrf](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/agungmrf/32/50700_2.png) [@agungmrf](https://community.glideapps.com/u/agungmrf)\
**Post date:** [November 22, 2022, 8:30am UTC](https://community.glideapps.com/t/how-can-i-group-this-data-by-department-any-idea/54683/4 "2022-11-22T08:30:30Z")

</div>

So the product folder is still 1

---

<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:** [November 22, 2022, 8:44am UTC](https://community.glideapps.com/t/how-can-i-group-this-data-by-department-any-idea/54683/5 "2022-11-22T08:44:56Z")

</div>

I don’t really understand. I don’t see any Product related table or column in your screen shots.

Reading between the lines, you most likely need to create a relation and use that as the source of your collection, but based on what I see it’s very difficult to say exactly how that should be configured.