# Sort data by company in admin side **URL:** \ **Category:** Ask for Help\ **Created:** [July 29, 2024, 5:36pm UTC](https://community.glideapps.com/t/sort-data-by-company-in-admin-side/75249 "2024-07-29T17:36:42Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![karishah](https://avatars.discourse-cdn.com/v4/letter/k/53a042/32.png) [@karishah](https://community.glideapps.com/u/karishah)\ **Post date:** [July 29, 2024, 5:36pm UTC](https://community.glideapps.com/t/sort-data-by-company-in-admin-side/75249/1 "2024-07-29T17:36:42Z")
Hi! I am creating a client dashboard with an external and internal side. I want to be able to create a page in which the admin can choose a client to see their data and it filters their data out. I already have their data linked to the client in my Glide tables but I cannot figure out how to create a filter to show only certain rows by client. Any assistance is appreciated! ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [July 29, 2024, 11:12pm UTC](https://community.glideapps.com/t/sort-data-by-company-in-admin-side/75249/2 "2024-07-29T23:12:15Z")
Wouldn’t it be easier for you if the admin clicks on the user’s row to view their data? If you’re aggregating data already on each user’s row, then that would make your building experience much easier. If your admin has to choose a client, let’s say using a choice component, you would have to do relation(s) & lookups to retrieve the data to be displayed on that same screen. I guess an alternative for you is still using the choice component, but use a Custom Collection component, filter to the row of the chosen user, and display data on that element. ---
**Author:** ![karishah](https://avatars.discourse-cdn.com/v4/letter/k/53a042/32.png) [@karishah](https://community.glideapps.com/u/karishah)\ **Post date:** [July 29, 2024, 11:34pm UTC](https://community.glideapps.com/t/sort-data-by-company-in-admin-side/75249/3 "2024-07-29T23:34:38Z")
What do you mean clicking on the user’s row? ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [July 29, 2024, 11:38pm UTC](https://community.glideapps.com/t/sort-data-by-company-in-admin-side/75249/4 "2024-07-29T23:38:41Z")
I mean you show a list of users and the admin can click on any of them to show a details screen/new screen, where you build your components to see each user’s data. ---
**Author:** ![karishah](https://avatars.discourse-cdn.com/v4/letter/k/53a042/32.png) [@karishah](https://community.glideapps.com/u/karishah)\ **Post date:** [July 29, 2024, 11:43pm UTC](https://community.glideapps.com/t/sort-data-by-company-in-admin-side/75249/5 "2024-07-29T23:43:46Z")
I think my situation is a little more complicated because I have multiple pages to show multiple types of data. It is already filtered by by each page having a type of data (column) per page but now I want the ability to filter by client (row) on the page. ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [July 29, 2024, 11:50pm UTC](https://community.glideapps.com/t/sort-data-by-company-in-admin-side/75249/6 "2024-07-29T23:50:38Z")
> **[Query Column | Glide Docs](https://www.glideapps.com/docs/automation/computed-columns/query-column)** > > Create complex relations in your data with conditional filtering, sorting, and limits. Then maybe using a query column is your best bet, and use your aggregation column (e.g rollup) around the query. ---
**Author:** ![karishah](https://avatars.discourse-cdn.com/v4/letter/k/53a042/32.png) [@karishah](https://community.glideapps.com/u/karishah)\ **Post date:** [July 29, 2024, 11:51pm UTC](https://community.glideapps.com/t/sort-data-by-company-in-admin-side/75249/7 "2024-07-29T23:51:07Z")
Perfect, thank you so much for the help! I will look into the query column.