How to create new worksheet items

You create new worksheet items when you want to analyze different data using items that might not be in the business area. For example, you might want to create a three month moving sales average.

For more information about adding an existing item to a worksheet, see "How to add items to worksheets".

To create a new worksheet item:

1. Display the worksheet that you want to edit.

2. Choose Edit | Worksheet to display the "Edit Worksheet dialog".

   
   Description of the illustration ed1.gif
   
   

3. Click New and choose one of the following:

   • to create a calculation, select New Calculation (for more information, see "How to create calculations")

   • to create a percentage, select New Percentage (for more information, see "How to create percentages")

   • to create a total, select New Total (for more information, see "How to create totals")

4. Click OK to save the changes you have made and close the dialog.

   Discoverer updates the worksheet with the changes that you specified.

Notes

• To quickly create a new worksheet item, select an item in the Selected Items pane and click one of the 'add item' buttons (e.g. Add Calculation button, Add Percentage button). For more information, see "About dragging and dropping items in the Discoverer work area").