In your OLAP cube or Data Model PivotTable, pick an item (like Accessories in our example) in the field (like the Category field in our example).

Dijet cnc lathe tool carbide insertfor sale

Drilling into large amounts of data in a PivotTable hierarchy has always been a time-consuming task with lots of expanding, collapsing, and filtering.

DIJETindustrial CO., ltd

If you have the Excel desktop application, you can use the Open in Excel button to open the workbook and drill into PivotTable data.

DijetQM mini

You cannot drill down in flat hierarchies (such as hierarchies that show attributes of the same item but don’t provide data on a next level) or other hierarchies that don’t have data on multiple levels.

The Quick Explore feature lets you drill into your Online Analytical Processing (OLAP) cube or Data Model-based PivotTable hierarchy to analyze data details on different levels. Quick Explore helps you navigate to the data you want to see, and acts like a filter when you drill down. The button shows up whenever you select an item in a field.

Dijetcatalogue

In your OLAP cube or Data Model PivotTable, pick an item (like Accessories in our example) in the field (like the Category field in our example).

Dijettools distributors

After drilling down, you can drill back up to analyze summary data. While Undo on the Quick Access Toolbar gets you back to where you started, drill up lets you take any other path back up so you can get bigger picture insights.

You cannot drill down on named sets (sets of items you use frequently or that combine items from different hierarchies).

DIJETinserts

If you have grouped items in your PivotTable, you can drill down on a group name the same way you drill down on other items.

You can drill up multiple levels of a hierarchy at once. Right-click the item you want to drill up on, click Drill Down/Drill Up, and then pick the level you want to drill up to.

Dijettools

Image

Dijetcutting tools

You can drill up multiple levels of a hierarchy at once. Right-click the item you want to drill up on, click Drill Down/Drill Up, and then pick the level you want to drill up to.

After drilling down, you can drill back up to analyze summary data. While Undo on the Quick Access Toolbar gets you back to where you started, drill up lets you take any other path back up so you can get bigger picture insights.

Drilling into large amounts of data in a PivotTable hierarchy has always been a time-consuming task with lots of expanding, collapsing, and filtering.

If you have grouped items in your PivotTable, you can drill down on a group name the same way you drill down on other items.

You cannot drill down in flat hierarchies (such as hierarchies that show attributes of the same item but don’t provide data on a next level) or other hierarchies that don’t have data on multiple levels.

You cannot drill down on named sets (sets of items you use frequently or that combine items from different hierarchies).

The Quick Explore feature lets you drill into your Online Analytical Processing (OLAP) cube or Data Model-based PivotTable hierarchy to analyze data details on different levels. Quick Explore helps you navigate to the data you want to see and acts like a filter when you drill down. The button shows up whenever you select an item in a field.