How to summarize sorted data based on many criteria

Hi,

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

image

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.

Probably you can do it like this.

1 Like

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

Do you mean filter or sort?

I want to sum filtered data.

+1 for easy rolling up filtered values

Hi,

Sounds like solution, plz share an example.