Powers executive reports with subtotals and grand totals: sales by region→country→city with totals at each level, revenue by year→quarter→month with period totals.

Financial Reporting

Executive financial statements with department, category, and grand totals

Financial Reporting

SELECT department, category, SUM(amount) AS total FROM expenses GROUP BY ROLLUP(department, category);

CFO reviews expenses at multiple levels: by category within department, department totals, and company grand total in single report.

All