Filter | Opens the Filter dialog box. | Ctrl+L | * |
Sort Ascending | Sorts the selected column values in ascending order (alphabetical or numeric). | | * |
Sort Descending | Sorts the selected column values in descending order (alphabetical or numeric). | | * |
Add Computed Item | Opens the Insert Computed Item dialog box. | | * |
Add Grouping Column | Opens the Grouped Column dialog box. Use to merge dimension labels into new groupings and aggregate the associated data. | | * |
Add Date Groups | Separates date-type items into year, quarter, and month items. | | |
Modify Column | Use to modify a computed column or a group column. | Ctrl+M | |
Remove | Removes the selected column (or data layout item). | Del | * |
Break Total | Opens the Insert Break Total dialog box. | | * |
Grand Total | Opens the Insert Grand Total dialog box. | | * |
Hide Column | Hides the selected column from view. | | * |
Unhide Column | Opens the Unhide Column dialog box. | | * |
AutoAdd Columns | Automatically adds columns in the Content pane for all requested items. If not selected, no columns are displayed in the Content pane. Turn this option off to manually add columns for requested items. | | |
| Aggregate Shared Members | If the “Aggregate Shared Members” option is enabled, the total is included for the initial shared member and for any parent members above it: | | |