Showing grand totals for columns in cross tables
You can show a grand total for each category column in the cross table. A grand total displays the resulting value for the column after applying the aggregation method that is selected on the cell values axis. For example, a grand total can indicate a 'grand sum' or a 'grand average'.
In the cross table below, the aggregation method 'Sum' is used to aggregate the 'Sales' values, and accordingly, Grand total shows the result of summing the values in each cross table column.


Note: The aggregated values for the grand totals are not calculated based on the visible, already aggregated column values. Instead, the grand total calculation goes back to the underlying data table, and its data row values. For example, if 'Average' is used as aggregation method, the Grand total average of a column takes into account all the data rows on which the column values are based, and not only the averages shown in the cross table column.
Procedure
Copyright © TIBCO Software Inc. All rights reserved.