ACROSS

Family: Calculation context

The other dimensions stay.

Syntax

1
TOTAL(measure, ACROSS(dimension, ...))

Arguments

Returns

Nothing of its own. It sets the grouping of the call that holds it.

Usage notes

• The query’s filters stay, those on the removed dimensions included. EVAL with REMOVE drops them as well.
• A call takes one BY or one ACROSS, not both.

Example

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

1
SELECT
2
  orders.region AS "Region",
3
  orders.channel AS "Channel",
4
  EVAL(orders.sum__quantity) AS "Units",
5
  MEASURE('region_units', TOTAL(orders.sum__quantity, ACROSS(orders.channel))) AS "Units on All Channels"
6
FROM kater_dataset.orders AS orders
7
WHERE
8
  KATER__IS_EQUAL_TO(orders.region, 'AMER')
9
GROUP BY
10
  orders.region,
11
  orders.channel
12
ORDER BY
13
  2

See also

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