{ let $doc := (collection("000572517_SEPTEMBER_13_1_AAAfB1AAEAAAjlUAAB")//CONN[@NO = (9878727704)]/../ITEMIZED/TRANSACTION[@Type = "AT&T 800 Global"]/CALL_TYPES/DATA/R) for $data in $doc let $groupByValue1 := data($data/C2) group by $groupByValue1 order by $groupByValue1 return { {distinct-values(data($data/C2))}, {count(data($data/C2))}, {sum(data($data/C9))}, {sum(data($data/C10))}, {sum(data($data/C11))}, {100*sum(data($data/C11)) div sum(data($data/C10))}, {sum(data($data/C10))+sum(data($data/C11))}, {(sum(data($data/C10))+sum(data($data/C11))) div sum(data($data/C9))}, {sum(data($data/C9)) div count(data($data/C2))} } }