You can only change the totals position on rows and columns. The dimension you change the totals position for must contain totals or other types of summary method.
This setting can be saved with the view and is independent of any sorts that are based on the data.
Totals position follows these formatting conventions:
- For groupings of totals, the sort is done within the peer group of totals at the same level of the hierarchy. For the options ‘totals before' and ‘totals after' the hierarchical structure remains in place, but the sort is done amongst siblings within each subtotal.
- For the options ‘totals at start/end' all items within the same level are grouped together and sorted amongst their peer group. Levels are counted by starting at the top of the tree and working down.
To change the totals position:
- Select Totals Position
A dialog box displays.
from the toolbar. - Select a totals position. The available options are:
- Group at start, which positions all of your totals at the top of, or the left of, the selected axis
- Before, which positions your totals above, or to the left of, the summarized values
- After, which positions your totals below, or to the right of, the summarized values
- Group at end, which positions your totals at the bottom of, or the right of, the selected axis
- Select OK to confirm.
You can also change the totals position when you Sort .