Available Items pane: Calculations tab

Use this tab to see the calculations, percentages, and totals available for use in the worksheet, and to create and edit calculations, percentages, and totals. For example, you might want to add an existing calculation to the worksheet. For more information about options on the Available Items toolbar, see "Available Items pane".

For more information, see:

"Using calculations"

" Using percentages"

"Using totals"

"About Discoverer's drag and drop features"

List

Use this drop down list to select the type of calculations to display in the <Items list> below, as follows:

choose 'All Items' to see all available calculations, percentages, and totals
choose 'Selected Items' to see calculations, percentages, and totals related to items currently included in the worksheet
choose a particular worksheet item (for example, Profit SUM) to see calculations, percentages, and totals active on that item

Use this list to see the calculations, percentages, and totals available for use in the worksheet, and to add and to remove calculations, percentages, and totals to and from the worksheet.

Click the plus (+) and minus (-) buttons next to a calculation category (for example, My Calculations, My Percentages, My Totals) to expand and collapse the category.

The categories prefixed with 'My...' contain worksheet items that you own and that you can edit and delete. Categories prefixed with the business area name are read-only items created by the Discoverer manager that you can use but not edit or delete.

To add a calculation to the worksheet, do one of the following:

Drag and drop a calculation from the Calculations tab into the worksheet area.
Drag and drop a calculation from the Calculations tab into the Selected Items pane (if displayed).
Select a calculation and click the Add to Worksheet button on the Available Items toolbar (for more information, see "Available Items pane"). Alternatively, you can right-click on an item and select Add to Worksheet from the right-click menu.

To edit or remove a calculation, do one of the following:

Select a calculation and click the Edit button on the Available Items toolbar (for more information, see "Available Items pane").
Select a calculation and click the Remove from Worksheet button on the Available Items toolbar (for more information, see "Available Items pane").

To select multiple items at a time, hold down the control key (Ctrl) when you select items. Items currently displayed on the worksheet are marked with a checkmark.

For descriptions of icons used in the <Items list>, see "About icons used in the Discoverer item navigator".