See SR 26/07/24 for info from Ella and Rui (right-click)This is where you perform a quick keyword filter, or access the Focus and Advanced filter features.
Focus
Select data what about this first?
The Focus tool displays a subset of your data in the grid. After you select one or more rows of data, you can use the Focus tool to isolate those selected rows from the rest of the dataset. You can then take your analysis further, concentrating on those specific rows of data.
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).
o undo the focus action and revert to the full list of rows in the grid:
(Optional) Click the Select button in the top-left corner of the grid to retain your row selections when you revert to the full list of rows*.
Click the X on the corresponding dimension button.
| Info |
|---|
*Your selections might not always display on the screen; they might be listed on another page of the grid. You can move through the pages to find them. |
not available?
Filter box
Right-click filter
The right-click filter allows you to do an advanced search based on a condition directly from the grid while you're looking at the data you're interested in. This feature is particularly powerful when you use it on a custom calculaiton column. You can then hide or delete the custom columns without affecting the filtered results.
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.
Search for similar or comparative data (right-click filter)
Advanced filter
The advanced filter feature is still in development. For now, it displays the results of the focus and filter actions you’ve applied on the grid.