Grand Total Issue in Cross Table of Spotfire

Question

When I use FIRST(CG1) in 'Cell Values' the grand total is not summing up instead its showing one of the values from the result of FIRST(CG1).

Please advise if we have to always use sum(XXX) to get the grand total summed up.

Answer 1

Short answer, yes if you want the Grand Total to be a summation of your data. Applying a grand total to a different aggregation will have different results.

• AVG will average the averages of your Category Axis
• MAX will take the MAX of the Max for each category
• Cumulative Sum will take the "Last" value in your Category since it doesn't have any additional values to SUM up.
• Product will take the Product of Products
• First and Last you are already aware of.