ROLLUP & CUBE: Overview

Use ROLLUP for hierarchical subtotals

Apply CUBE for multi-dimensional analysis

Understand GROUPING function to identify subtotal rows

Create grand totals and intermediate subtotals

Choose between ROLLUP, CUBE, and GROUPING SETS

Build executive reports with totals at multiple levels

Use ROLLUP for hierarchical subtotals

Apply CUBE for multi-dimensional analysis

Understand GROUPING function to identify subtotal rows

Create grand totals and intermediate subtotals

Choose between ROLLUP, CUBE, and GROUPING SETS

Build executive reports with totals at multiple levels