On the Filter tab, you can specify exactly one key figure as a filter if no key figure has been selected on the axles. The values of this key figure are displayed in the cells when the query is executed.
Option | Description |
---|---|
Operator | Description |
Equal | Equal to |
LessThan | Less than |
GreaterThan | Greater than |
LessEqual | Less than or equal to |
GreaterEqual | Greater than or equal to |
ContainsPattern | Contains pattern |
You want to define a query that only contains characteristics in the columns and in the rows. Every query must contain at least one key figure however. You can ensure this by adding a key figure to the Filter: Fixed Values and - if required - setting operators and excludes.