Adding Totals to a View

Before you start

You must have one of the following user type permissions:

• BI Author Limited

• BI Author Developer

• BI Tenant Administrator

Home > Oracle Business Intelligence > Catalog or, for Oracle Analytics,

Home > Oracle Analytics > Catalog

Here's what to do

1. Edit the analysis.
2. In the results tab, click Edit View for the view.
3. Display the Layout pane for the view.
4. To add grand totals to the entire view:

   • For a table, in the Columns and Measures drop target, click the Totals button, then click the location such as Before.

   • For a pivot table, in the Rows or the Columns drop target, click the Totals button, then click the location such as After.

5. To turn on and off the totals that apply to all the values in the drop target, click the Totals button beside the drop target name, such as Sections. Then select the location for the total, such as Before the data items. A totals area is added to the view.