TOTAL

Family: Calculation context

Name the grouping with BY or ACROSS.

Syntax

1
TOTAL(value, BY(dimension, ...) | ACROSS(dimension, ...) [, SET(...)] [, IGNORE_FILTERS(...)])

Arguments

Returns

The total on each row of the result.

Usage notes

• A measure is worked out again at the broader grouping. A ratio’s total is the ratio of the totals, and a distinct count is counted again. Kater does not add up the rows shown.
• Any other number, such as a dimension or a measure already in a changed context, is added up over the query’s rows, as a spreadsheet’s column total is.
• The query’s filters stay. The total counts the rows before QUALIFY and the row limit.
• A total of a measure has the measure’s name. When the query also shows the measure, declare the total with its own name, as the example does.
• KATER__TOTAL is the table’s Total row, which adds up a column over every row of the query.

Example

This Sandbox query reads the sample shop’s orders. The table shows the rows that Kater gave.

1
SELECT
2
  orders.channel AS "Channel",
3
  EVAL(orders.sum__quantity) AS "Units",
4
  MEASURE('all_units', TOTAL(orders.sum__quantity, BY())) AS "All Units"
5
FROM kater_dataset.orders AS orders
6
GROUP BY
7
  orders.channel
8
ORDER BY
9
  1

See also

• Change a measure’s context
• Other functions in Calculation context: SHARE_OF_TOTAL, VALUE_FOR, CALCULATE_ACROSS, CALCULATE_BY, CALCULATE_PER, RATIO, RUNNING_TOTAL, MOVING_AVERAGE, CUMULATIVE_SHARE, BY, ACROSS, IGNORE_FILTERS