Query editor
selectcasewhen amt <= 50 then 'a_1-50'when amt <= 100 then 'b_50-100'when amt <= 500 then 'c_100-500'when amt <= 1000 then 'd_500-1k'when amt <= 2000 then 'e_1k-2k'else 'f_2k+'end as "$ME Amt",count(1) as Walletsfrom(select to_owner,SUM(claim_amt) as amtfrom query_4402471group by 1-- order by amt) agroup by 1order by 1