Brio Software
Technical Publications
Home Previous Next Index Glossary
Data Analysis and Reporting with Intelligence Clients

Pivot Menu Command Reference

The following table provides a quick reference to the commands available on the Pivot menu and lists any related shortcuts.

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.
 
 



Home  |  Previous |  Next  |  Index |  Glossary

Privacy/Legal | Copyright 2002 Brio Software, Inc.