Skip to main content

Limitations

Subtotals are still evolving. Current limitations:

  • SUM only. The default subtotal line always sums. There's no built-in way to choose an average, a count, or another aggregate per rule.
  • No "Total" wording by default. Default captions show the member name only. Use a Block Format to add a label.
  • One line per block. Use a single-line Block Format for subtotal lines. Multi-line blocks aren't supported yet.
  • Formatting Rules inside a Block Format. A Formatting Rule condition on a Block Format's template that uses a cell reference is read against the block's own layout, not against where the subtotal line lands.
  • Extends To is ignored on a Block Format template used for a subtotal line, as it is for Block Formatting.
  • Dataset spaces only. Row and Column spaces have no dimensions to break on.
  • Matrix only. Table and Pivot widgets don't support Subtotals.