Drilling, Pivoting, and Retaining Data

In This Section:

Drilling Up to Less Detail

Drilling Down to More Detail

Sampling Data

Pivoting Data

Pivoting on Formatted Worksheets

Restoring the Previous Database View

Retaining Data Sets

Removing Data Sets

Navigating Through Worksheets Without Retrieving Data

Enabling Compatibility Between Spreadsheet Add-in and Smart View

Using Mouse Actions to Pivot, Retrieve, and Drill Up and Down

Enabling Double-Clicking to Browse LROs

Drilling Down or Up On Shared Members

Drilling Down on Level 0 Attributes