The Grand Total option displays a row or column of totals for a selected dimension. The totals can be displayed before or after the other rows/columns.
To show grand totals for a dimension:
Click on the dimension heading and select Grand Totals from the dimension menu, or click Grand Totals in the Dimension tab of the ribbon.
To display totals after other data:
After displaying the totals, open the dimension menu and select the Show Totals Below option, or click Totals Below on the Dimension tab of the ribbon.
The total row or column will move to the end of the data (bottom row or rightmost column).
To hide grand totals for a dimension:
Click on the dimension heading and deselect Grand Totals from the dimension menu, or click Grand Totals on the Dimension tab of the ribbon.
Example
In the following example, grand totals are displayed for the Product Model Categories dimension.