Product: TIBCO Spotfire®
The Grand Total in this Cross Table is not the sum of Cross Table elements.
The Grand Total in this Cross Table is not the sum of Cross Table elements. This is due to a common misunderstanding of how a Cross Table works. The "Grand Total" of a row or column in a Cross Table is not the sum of the elements in that row or column. The "Grand Total" columns and rows in a Cross Table are actually "grand aggregation" columns and rows. That is, they are the result of applying exactly the same aggregation method or custom expression to the entire data set represented by the column or row in the Cross Table as has been applied to produce the values in each of the cells in that column or row. This means, for example, that a "Grand Total" for a column of Averages is actually a Grand Average, and a "Grand Total" for a row of Medians is actually a Grand Median. This is also true for each row and column "Subtotal" in a Cross Table.