Spotfire® Web Client User Guide

Displaying grand totals and subtotals as sums of the cell values

By default, grand totals and subtotals in a cross table are calculated using the same aggregation or expression that is used for calculation of the cell values, and the calculations are based on the underlying data table rows. However, it is possible to base the totals calculations on the aggregated cell values. Then totals will be calculated as the sum of the cell values, no matter the expression used for the cell values.

Procedure

  1. Right-click the cross table, and select Properties in the opened menu.
  2. Select Totals.
  3. Under Display totals, select the totals to be visible in the cross table.
  4. If any subtotals are displayed, select their position; Before values or After values.
  5. Settings of calculations lists the expressions used for calculating the cell values for the different expressions on the Cell values axis, and what data the calculations are based on . Click the expression, whose totals you want to calculate as a sum of the cell values.
  6. Select As sum of cell values under Calculate totals.

Results

Any totals for the expressions selected in the last step are calculated as sums. It is also indicated in the list that they are calculated as Sum of cell values.