Add Selected Items | Adds the selected item as a Column Label, Row Label, or Fact. | | * |
Remove Selected Items | Removes the selected item. | Del | * |
Modify | Modifies the selected computed item. | Ctrl+M | * |
Sort | Reorders the selected item by labels, by values, ascending, or descending. | | |
Add Totals | Adds the selected item to the Measures pane. | | * |
Add Computed Item | Adds a new data item derived from calculations performed on an item. | | * |
Add Cume | Adds cumulative totals to break totals by dimension and restarts them at each dimensional grouping. | | * |
Data Function | Applies a prebuilt data function to the selected item. | | * |
Drill Anywhere | Enables you to drill to any item. | | * |
Drillup | Returns the original view of data that you drilled. | | * |
Focus On Items | Updates the pivot table to include only the selected data. | | * |
Hide Items | Hides the selected item. | | * |
Show Hidden Items | Restores the selected hidden item. | | * |
Show All Items | Updates the pivot table to include all items. | | * |
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. | | * |
Refresh Data | Updates the data according to the selected option. Select between After Process, When Section Displayed, Manually, or Refresh Now. | | |
Pivot Options | Enable surface values, true computed totals, and null facts in computed items. | | |