Skip to main content
A Variable lookup can select one Dimension item, a chosen set of items, or every item in a Dimension.

​
Select one item

This changes Department to Sales while other dimensions continue to follow the current segment.

​
Select several items

Use a set:
A multi-value lookup is summed when no aggregation function is written. Add the intended function when another behavior is clearer:

​
Exclude selected items

​
Select every item

This is useful for totals, averages, and percent-of-total calculations.

​
Filter with an expression

Use where when the selected segment must meet an additional condition:
In this example, the condition keeps only Department segments whose Revenue exceeds 10,000. Use this when you need to refer to the current formula context from within a filter:

​
Combine dimensions

Keep filters as narrow as the business rule requires. If the current segment already matches the intended result, use a plain Variable reference.