This is where you perform a quick keyword filter, or access the Focus and Advanced filter features.
...
| Info |
|---|
The filtering options in Flexible Variance are similar to those in the other modes. This page provides links to related documentation pages, but please keep in mind that there might be some differences there. The significant differences are explained below. |
There are four ways to filter the data in Flexible Variance mode: Focus tool, filter box, right-click filter and advanced filter.
When you filter data using any of these methods, chips appear in the right side of the filter box to help you keep track of what you've done. When there are two or more
...
...
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.
...
:
The And indicator informs you that the AND condition is applied to the filters. You can change this to an OR condition the Advanced filter panel.
The Clear button allows you to instantly clear all your filters and return to the default view of the data.
1. Focus tool
The Focus button allows you to view a subset of your data in the grid.
...
...
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
...
in the grid to activate the Focus button, then click it to filter out all the other data. Your filter displays as a chip on the right of the filter box.
While the focus tool currently works differently from other modes, you might find these pages useful:
Select data. Currently, is isn’t possible to select multiple separate rows, but you can click and drag to select multiple consecutive rows. Also, when you select a row on one page of the grid and then move to another page, you lose your first selection.
Focus on data. Currently, it isn’t possible to exclude data or lock selections.
2. Filter box
The filter box sitting directly above the grid allows you to you perform a quick a keyword search to filter the grid.
Type a keyword into the box and press Enter. This action automatically performs an
...
...
...
...
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.
Right-click a cell in a column to display the context menu, then select the filter you want to apply.
...
...
...
...
...
...
...
you can switch between using and AND or OR condition.
In a future release, you'll be able to perform more advanced filtering based on conditions and using groups.
On this page
| Table of Contents | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
|