To do grouping, sum etc add the summary attriute to your result columns for example : { name: "tranid", join: "appliedtotransaction", }