You can control totals by individual levels or by an entire axis. Changing totals for an entire axis is a helpful shortcut when there are many levels in the view definition and you want all their totals to be shown or all hidden. When you change totals by axis, all new levels added after the change will have their Total property set to match the Totals Default setting for that axis. For example, if the Totals Default is changed to No, then the Total property for a new level will be No. However, you can change the Total property for the new level to be different from the axis setting.
Note: Totals for measure items are controlled separately from totals for levels.
See also Enable or Disable Totals by Axis and Enable or Disable Totals for Levels.
This view has five levels on rows. The third level has been drilled to in the view. The Totals Default for the rows axis is Yes, but some levels had their Total property customized to be different from the axis. Totals are hidden for Region and RepBroker.
The Rows axis filter is right-clicked. We select Totals then Yes from the pop-up menu.
This action resets the Total property for all levels to Yes, and the Totals Default for the axis remains at Yes. There are now totals displayed for Region and RepBroker.
This view has several levels on columns, and currently one level is displayed. All the levels on the axis have totals enabled.
The Columns folder in view explorer is right-clicked. We select Totals then No from the pop-up menu.
The Totals Default changes to No in the Properties window for that axis. In the refreshed view, totals for all levels on columns are hidden.
A hierarchy is added to columns and moved to be the first level on that axis. The Totals property for its level is set to No automatically, based on the Totals Default setting.
The Total property for the level is changed to Yes. Totals display in the refreshed view for the newly added level.
