> ## Documentation Index
> Fetch the complete documentation index at: https://docs.cfo.ai/llms.txt
> Use this file to discover all available pages before exploring further.

# Filter by dimension values

A property lookup can select one dimension value, several values, or every value of a dimension.

## Select one value

```text theme={null}
Revenue[Department: "Sales"]
```

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

## Select several values

Use a set:

```text theme={null}
Revenue[Department: {"Engineering", "Product", "Design"}]
```

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

```text theme={null}
average(Revenue[Department: {"Engineering", "Product", "Design"}])
```

## Exclude values

```text theme={null}
Revenue[Department: NOT {"Engineering"}]
```

## Select every value

```text theme={null}
Revenue[Department: ANY]
```

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

## Filter with an expression

Use `where` when membership depends on another value:

```text theme={null}
Revenue[Department: where Headcount > 0]
```

Inside a `where` filter, a plain property refers to each candidate value. Use `thisSegment` when you need to compare a candidate with the current cell:

```text theme={null}
Revenue[Department: where Headcount > thisSegment.Headcount]
```

## Combine dimensions

```text theme={null}
Revenue[Region: "West", Department: "Sales"]
```

Keep filters as narrow as the business rule requires. If the same rule applies to the current segment, prefer a plain property reference.