I have a table like this: Shops Location Total 1. CK SF 1000 2. CK LA 877 3. CK NY 543 4. CK BOS 436 5. OG NY 2112 6. OG DET 100 7. OG ATL 876 8. OG LA 421 I want a table/report like this: Shops Location Total 1. CK LA 877 2. CK NY 543 3. OG NY 2112 4. OG LA 421 Code I have: |tstats count where index=us-shops Shops IN (CK OG) Location=* by Shops,Location |sort - count| streamstats count as rank by Shops | where rank < 9|stats sum(count) by Shops,Location | rename sum(count) as Total ... View more