Table Menu Commands
|
Command
|
Description
|
Keyboard Shortcut
|
Shortcut Menu
|
|
Limit
|
Opens the Limit dialog box.
|
[Ctrl+L]
|
4
|
|
Sort Ascending
|
Sorts the selected column values in ascending order (alphabetical or numeric).
|
|
4
|
|
Sort Descending
|
Sorts the selected column values in descending order (alphabetical or numeric).
|
|
4
|
|
Add Computed Item
|
Opens the Insert Computed Item dialog box.
|
|
4
|
|
Add Grouping Column
|
Opens the Grouped Column dialog box. Use to merge dimension labels into new groupings and aggregate the associated data.
|
|
4
|
|
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 Outliner item).
|
[Del]
|
4
|
|
Break Total
|
Opens the Insert Break Total dialog box.
|
|
4
|
|
Grand Total
|
Opens the Insert Grand Total dialog box.
|
|
4
|
|
Hide Column
|
Hides the selected column from view.
|
|
4
|
|
Unhide Column
|
Opens the Unhide Column dialog box.
|
|
4
|
