Selecting Totals and Percentages Settings

The Totals and percentages settings dialog:

• defines how you want totals and custom groups to be calculated (double-click in the Total function cell to see the choices (or single-click and press F2), and/or
• allows you to display both values and percentages in the table view (select the Display values and percentages together checkbox).

To open the Totals and percentages settings dialog, do one of the following:

• Click Table options / Chart options > Totals and percentages settings.
• Select View menu > Table options / Chart options > Totals and percentages settings.

Note: This dialog box has no effect on tables that do not include totals or custom groups. These are both configured on the dimension definition page for the dimension on which you want these calculations performed (see Dimension definition area).

To define how totals interact with the measures:

• Double-click the Total function cell that corresponds to the hierarchy/measure total you want to define.
• Select one of Aggregate (default), Sum, Max or None. Aggregate is a “smart sum” that aggregates ratios properly, and in the case of many-to-many relationships, does not double count. Sum simply adds up all participating members. Max takes the highest value of the aggregated members and None does not add anything and displays a null for the total or group.