SOQL Total and Subtotals

Simple Explanation

To get Totals and Subtotals directly from SOQL we can use GROUP BY ROLLUP

let's take this sample data of Account

Use Case :

Let’s say we want to query the Billing Country and Billing City along with their respective Annual Revenues. We also need the totals for each country as well as the grand total across all countries.

SELECT BillingCountry, BillingCity, SUM(AnnualRevenue)
FROM Account

WHERE BillingCountry != NULL AND BillingCity != NULL

GROUP BY ROLLUP(BillingCountry, BillingCity)

ORDER BY BillingCountry, BillingCity

This will result in this