Oracle Application Server Discoverer Plus User's Guide 10g (9.0.4) Part Number B10268-01 |
|
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 column of sales figures.
For more information, see:
Use this drop down list to specify which items you want to create a total for. You can specify a particular item or choose all items.
Use this drop down list to specify what type of total you want.
Use these radio buttons to specify where to display the total.
Use this radio button to display a grand total of all values in the worksheet.
Use this radio button to display a total for the item row.
Note: This field is only displayed when you add a total to a crosstab worksheet.
Use this radio button to calculate a total for a sub-group. Select an item from the drop 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.
Use this check box to not display a total for a single row, where the row and total would have the same value.
Note: This field is called Don't display total for single rows or columns when you add a total to a crosstab worksheet.
Use these radio buttons to choose the scope of the total. For example, if a worksheet contains page items (i.e. items are displayed in the Page Items area), you might want to display a total at the bottom of each page.
Use this radio button to apply the total to data displayed on the worksheet. For example, if Calendar Month is displayed in the Page Items area, you display a grand total for each month.
Use this radio button to apply the total to all data in the worksheet. The total takes into account other page items not currently displayed on the worksheet. For example, if Calendar Month is displayed in the Page Items area, you display a grand total for all months.
This area shows you how your worksheet will look according to what options you specify.
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 drop down list on 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.
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.
Use this button to display the "Format Data dialog", where you change how the values look on the worksheet.
Use this button to display the "Format heading dialog", where you change how the item headings look on the worksheet.
|
![]() Copyright © 1999, 2003 Oracle Corporation. All Rights Reserved. |
|