Pivot Menu Commands
|
Command
|
Description
|
Keyboard Shortcut
|
Shortcut Menu
|
|
Add Selected Items
|
Adds the selected item as a Top Label, Side Label, or Fact.
|
|
4
|
|
Remove Selected Items
|
Removes the selected item.
|
[Del]
|
4
|
|
Modify
|
Modifies the selected computed item.
|
[Ctrl+M]
|
4
|
|
Sort
|
Reorders the selected item by labels, by values, ascending, or descending.
|
|
|
|
Add Totals
|
Adds the selected item to the Measures pane.
|
|
4
|
|
Add Computed Item
|
Allows you to add a new data item derived from calculations performed on an existing item.
|
|
4
|
|
Add Cume
|
Adds cumulative totals to break totals by dimension and restarts them at each dimensional grouping.
|
|
4
|
|
Data Function
|
Applies a prebuilt data function to the selected item.
|
|
4
|
|
Use Surface Values
|
Allows data functions to recalculate the values in the visible cells or surface of the pivot table
|
|
4
|
|
Drill Anywhere
|
Allows you to drill to any item.
|
|
4
|
|
Drillup
|
Returns the original view of data that you drilled.
|
|
4
|
|
Focus On Items
|
Updates the pivot table to include only the selected data.
|
|
4
|
|
Hide Items
|
Hides the selected item.
|
|
4
|
|
Show Hidden Items
|
Restores the selected hidden item.
|
|
4
|
|
Show All Items
|
Updates the pivot table to include all items.
|
|
4
|
|
Group Items
|
Groups the selected dimensions.
|
[Ctrl+G]
|
|
|
Ungroup Items
|
Ungroups the selected dimension.
|
[Ctrl+U]
|
|
|
Restore Name
|
Restores the original name of a renamed item.
|
|
4
|
|
Refresh Data
|
Updates the data according to the selected option. Choose between After Process, When Section Displayed, Manually, or Refresh Now.
|
|
|
