Excel® 2013 On Demand

Drilling into PivotTable Data

When you add multiple tables to a Data Model or use data from an Online Analytical Processing (OLAP) cube, you can use the Quick Explore button to quickly drill into large amounts of complex data to view different levels of details in a PivotTable. When you select data in a field, the Quick Explore button (New!) appears, where you can drill down one item at a time. When you click the Quick Explore button, a callout appears, where you can select the data field and then drill to or drill down to the data. After you drill, you can use the same technique to drill up or use the Undo button on the Quick Access Toolbar. In addition to PivotTables, you can also drill a PivotChart. When you select a chart element, the Quick ...