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. | | * |