The visual totals feature controls how values for parent members are aggregated.
When visual totals are turned off, a parent member is always the sum of all child members (depending on the measure). When visual totals are turned on, and child members of the parent are displayed, the value for the parent member is the sum of the children that are present in the results. Children that are not present in the results are not included when calculating the parent value.
Consider the following example, where a year, 2002, is split out against it quarters and we have eliminated the second quarter:
|
|
Visual totals are off. CY 2002 is calculated as the total of all quarters, including Q2. |
Visual totals are on. CY 2002 is calculated as the total for only the visible quarters, thus excluding Q2. |
By default, visual totals is turned off.
Note: child members that have been removed due to a filter are still included in the parent value when visual totals are on.
Turning empty row and column suppression on or off
On the toolbar above the grid, click on the Options 
drop down button and select Use Visual Totals to enable or disable the use of visual totals.