This is where you perform a quick keyword filter, or access the Focus and Advanced filter features.
...
...
...
There are three ways to filter the data.
When two or more, see And indicator default filtering, can change to OR in ad search panel, and see the Clear button.
Focus
Select data what about this first? can’t select multiple separate rows. when select something on another page, you lose your first selection.
...
...
...
Select the row(s) you want to focus on, then click the Focus button.
The grid updates to display only your selected rows. Any totals or averages that display in the updated grid now relate only to the selected rows of data. The status bar above the grid identifies the selected data. The number of rows you have focused on displays in brackets on the corresponding dimension (which displays in blue).
to undo the focus action and revert to the full list of rows in the grid: lick the X on the chip in the filter box.
not available?
Exclude data can’t do it
Lock selections can’t do it
Filter box
...
...
...
...
...
Click the X on the chip to remove the filter. When you have two or more filters applied, you can click the red Clear button that displays next to the chips.
...
...
The right-click filter is available in the calculation and transaction columns. It’s contextual, so the available options, such as the comparable columns, depend on the column you are filtering.
...
...
...
...
...
...
...