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.