Showing grand totals for rows in cross tables
You can show a rand total for each category row in the cross table. A grand total displays the resulting value for the row 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 row.


Note: The aggregated values for the grand totals are not calculated based on the visible, already aggregated row 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 displayed Grand total is the calculated average of all the underlying data table rows, on which the cross table row values are based, and not only the averages shown in the cross table row.
Procedure
Copyright © TIBCO Software Inc. All rights reserved.