https://community.dynatrace.com/t5/DQL/Add-total-sales-and-categorize-via-dql/m-p/225043#M283 <P>hi&nbsp;<a href="https://community.dynatrace.com/t5/user/viewprofilepage/user-id/64547">@WellPP</a>&nbsp;</P> <P>I think you are looking for this query</P> <LI-CODE lang="markup">fetch bizevents | filter event.type == "com.easytravel.funnel.booking-finished" | fields amount, geo.country.name | summarize total = sum(amount), by:{geo.country.name} </LI-CODE> <P>&nbsp;</P> <P>Best,<BR />Sini</P> Wed, 11 Oct 2023 07:33:03 GMT sinisa_zubic 2023-10-11T07:33:03Z https://community.dynatrace.com/t5/DQL/Add-total-sales-and-categorize-via-dql/m-p/225020#M282 <P>How can I add up the total amount received and categorize by country?</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="WellPP_0-1696970957591.png" style="width: 400px;"><img src="https://community.dynatrace.com/t5/image/serverpage/image-id/14527iECC3EBC74718713C/image-size/medium?v=v2&amp;px=400" role="button" title="WellPP_0-1696970957591.png" alt="WellPP_0-1696970957591.png" /></span></P><P>&nbsp;</P> Tue, 10 Oct 2023 20:49:09 GMT https://community.dynatrace.com/t5/DQL/Add-total-sales-and-categorize-via-dql/m-p/225020#M282 WellPP 2023-10-10T20:49:09Z https://community.dynatrace.com/t5/DQL/Add-total-sales-and-categorize-via-dql/m-p/225043#M283 <P>hi&nbsp;<a href="https://community.dynatrace.com/t5/user/viewprofilepage/user-id/64547">@WellPP</a>&nbsp;</P> <P>I think you are looking for this query</P> <LI-CODE lang="markup">fetch bizevents | filter event.type == "com.easytravel.funnel.booking-finished" | fields amount, geo.country.name | summarize total = sum(amount), by:{geo.country.name} </LI-CODE> <P>&nbsp;</P> <P>Best,<BR />Sini</P> Wed, 11 Oct 2023 07:33:03 GMT https://community.dynatrace.com/t5/DQL/Add-total-sales-and-categorize-via-dql/m-p/225043#M283 sinisa_zubic 2023-10-11T07:33:03Z