# How to summarize sorted data based on many criteria

**URL:** <https://community.glideapps.com/t/how-to-summarize-sorted-data-based-on-many-criteria/14933>\
**Category:** Ask for Help\
**Created:** [August 29, 2020, 10:10am UTC](https://community.glideapps.com/t/how-to-summarize-sorted-data-based-on-many-criteria/14933 "2020-08-29T10:10:49Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![Md\_Jakir\_Hossain](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/md_jakir_hossain/32/2861_2.png) [@Md\_Jakir\_Hossain](https://community.glideapps.com/u/Md_Jakir_Hossain)\
**Post date:** [August 29, 2020, 10:10am UTC](https://community.glideapps.com/t/how-to-summarize-sorted-data-based-on-many-criteria/14933/1 "2020-08-29T10:10:49Z")

</div>

Hi,

My app is regarding inventory management, where devices are sorted based on req type, quantity type etc. Here is a screenshot.

![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/6/6e891e1d08be9e0edf90cd9548e6561b3ea30162.png)

Let cambium radio be device, need to sort out like…  
Total number of cambium radio when sorted as Qty\_Good=7  
Total number of cambium radio when sorted as Qty\_Faulty=5  
Total number of cambium radio when sorted as Transfer to STK-STR (Qty\_Good=3 & Qty\_Faulty=3)  
Total number of cambium radio when sorted as Req from STK-STR (Qty\_Good=0 & Qty\_Faulty=0)  
Total number of cambium radio when sorted as Return to STK-STR (Qty\_Good=4 & Qty\_Faulty=2)

I need your help. Thanks in advance.

---

<div class="post-metadata">

**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:** [August 29, 2020, 10:38am UTC](https://community.glideapps.com/t/how-to-summarize-sorted-data-based-on-many-criteria/14933/2 "2020-08-29T10:38:03Z")

</div>

> [@"Dynamic group-by" inline list](https://community.glideapps.com/t/dynamic-group-by-inline-list/14855/):
>
> Hi, in case this is not a common workaround, happy to share an approach to have an inline list “dynamically grouped by” a choice component. This enables users to choose how to group-by the results of the inline list (+ to reduce the nb of inline list by x if we had 1 by ‘group-by’ criteria) Challenge: I’ve got 1 tab for [Search] and 1 for [Content]; I had to separate them because the [Search] tab displays elements of various tabs. In the [Search] tab, I have a ‘choice component’ for the ‘gr…

Probably you can do it like this.

---

<div class="post-metadata">

**Author:** ![Md\_Jakir\_Hossain](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/md_jakir_hossain/32/2861_2.png) [@Md\_Jakir\_Hossain](https://community.glideapps.com/u/Md_Jakir_Hossain)\
**Post date:** [August 29, 2020, 11:42am UTC](https://community.glideapps.com/t/how-to-summarize-sorted-data-based-on-many-criteria/14933/3 "2020-08-29T11:42:29Z")

</div>

> [@Md\_Jakir\_Hossain](#):
>
> Let cambium radio be device, need to sort out like…  
> Total number of cambium radio when sorted as Qty\_Good=7  
> Total number of cambium radio when sorted as Qty\_Faulty=5

Hi,  
Is there any simple way for above sort out??

---

<div class="post-metadata">

**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:** [August 29, 2020, 4:33pm UTC](https://community.glideapps.com/t/how-to-summarize-sorted-data-based-on-many-criteria/14933/4 "2020-08-29T16:33:58Z")

</div>

Do you mean filter or sort?

---

<div class="post-metadata">

**Author:** ![Md\_Jakir\_Hossain](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/md_jakir_hossain/32/2861_2.png) [@Md\_Jakir\_Hossain](https://community.glideapps.com/u/Md_Jakir_Hossain)\
**Post date:** [August 30, 2020, 6:11am UTC](https://community.glideapps.com/t/how-to-summarize-sorted-data-based-on-many-criteria/14933/5 "2020-08-30T06:11:37Z")

</div>

I want to sum filtered data.

---

<div class="post-metadata">

**Author:** ![Gerard\_Fernandez](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gerard_fernandez/32/1183_2.png) [@Gerard\_Fernandez](https://community.glideapps.com/u/Gerard_Fernandez)\
**Post date:** [August 30, 2020, 10:36am UTC](https://community.glideapps.com/t/how-to-summarize-sorted-data-based-on-many-criteria/14933/6 "2020-08-30T10:36:53Z")

</div>

+1 for easy rolling up filtered values

---

<div class="post-metadata">

**Author:** ![Md\_Jakir\_Hossain](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/md_jakir_hossain/32/2861_2.png) [@Md\_Jakir\_Hossain](https://community.glideapps.com/u/Md_Jakir_Hossain)\
**Post date:** [August 30, 2020, 10:39am UTC](https://community.glideapps.com/t/how-to-summarize-sorted-data-based-on-many-criteria/14933/7 "2020-08-30T10:39:52Z")

</div>

Hi,

Sounds like solution, plz share an example.