New Total dialog (on a crosstab worksheet)

Use this dialog to create a new total on the worksheet. For example, you might want to analyze the worksheet in a new way by summing a row of sales figures.

For more information, see:

"What are totals?"

"About SUM and Cell SUM"

Which data point would you like to create a total on?

Use this pull down list to specify which items you want to create a total for. You can specify a particular item or choose all items.

What kind of total do you want?

Use this pull down list to specify what type of total you want.

Where would you like your total to be shown?

Use these radio buttons to specify where to display the total.

• Grand total at bottom

  Use this radio button to display a grand total of all values in the worksheet.

• Subtotal at each change in

  Use this radio button to calculate a total for a sub-group. Select an item from the pull down list below to define the item that you want to sub-group. For example, to calculate a total for each calendar month, you might choose 'Month' here.

Don't display total for a single row

Use this check box to not display a total for a single row, where the row and total would have the same value.

Which page items do you want to include?

Use these radio buttons to choose the scope of your percentage.

• Calculate totals only for current page items

  Use this radio button to apply the total to data displayed on the worksheet.

• Calculate totals only for all page items

  Use this radio button to apply the total to all data in the worksheet. Here, data for other page items not currently displayed on the worksheet is also included.

Example

This area shows you how your worksheet will look according to what options you specify.

What label do you want to be shown?

Use this field to specify what total label will be displayed on the worksheet. If the Generate label automatically check box is selected below, Discoverer creates a name for you. To enter a different label, clear the Generate label automatically check box and either type in a new label or choose a label from the pull down list to the right of the field. To change the default text style of the label, click the Format button and choose a text font, style, color and alignment.

Generate label automatically

Use this check box if you want Discoverer to create a total name for you. To change the default text style, click the Format button and choose a text font, style, color and alignment.

Format Data

Use this button to display the "Format Data dialog", where you change how the item values look on the worksheet.

Format Heading

Use this button to display the "Format heading dialog", where you change how the item headings look on the worksheet.