Advanced report examples using PIVOT and GROUPING SETS

In this tip I show how I combine GROUPING SETS and PIVOT to get crosstab-style reports without Excel.