There may be times when you want to hide or limit the columns or rows in your analysis. You can do this using the options available in the modify menu.
● The option HIDE under Selection, allows you to hide the selected columns or rows.
● The option Show Limit Display under Display, allows you to limit the number of columns and or rows you want to display in your analysis.
In this article:
1. Hide Items from your Analysis
There may be times when you choose to hide data in your analysis. You can select columns and/or rows and hide these from the view.
For the HIDE option to become available, you need to select a column or row.
- The HIDE option hides the selected row or column
- You can add items back into the analysis (unhide) by clicking on the label in the interactive title and using the Selector
While items are hidden from the view, they are still part of the overall calculations of the analysis. If you want these items to be excluded from the overall calculation of the analysis, you can use the Total (view) option.
- Select a column or row to hide and then choose the HIDE option
- You can select multiple rows or columns and then choose the HIDE option
- If necessary, change the total type to Total(view)
- To display the hidden items again, click the interactive title and change it in the Selector
Show Hidden Items
If you hide an item, you can use the Selector to make it visible again. Click on the axis label in the interactive title and click the checkbox to select the item.
- Click the interactive title to access the Selector
- Select the items you want to include in the analysis
2. Show Limit Display
Show limit display gives you the ability to limit the number of columns and/or rows displayed in your analysis to focus on key areas of interest.
Show limit display is dynamic, so it will adjust as your data updates or you interact with analysis filters.
- Expand the Show limit display icon
- Enter the number of columns and/or rows you want to display
- Click on Show limit display option (it turns orange), your analysis adjusts based on your selection
After entering the number of columns and/or rows to wish to limit, click on the limit display icon to 'activate' limit display.
Limit display: number of columns and rows displayed
- For rows, the order (top "n") goes from top to bottom (excluding the total).
- For columns, the order (top "n") goes from left to right (excluding the total), except for time axes, where it counts from the last period (i.e. right to left).
- For a nested group, limit display is only applied on the inner level.
- Columns or rows suppressed by ZERO or NULL, are still considered as part of the top "n" items to show. This means that your analysis may show fewer columns or rows to what you have defined.
- After applying limit display, if you choose to HIDE a column or row the analysis will display the next available item, that is, it will always show the number defined.
- After applying limit display, if you choose to deselect an item from a column or row the analysis will display the next available item, that is, it will always show the number defined.
- While items are not displayed in the view, they are still part of the overall calculations of the analysis. If you want these items to be excluded from the overall calculation of the analysis, you can use the Total (view) option.
- Show limit display on time axes, counts from the last period.
Combining Limit Display with Rank allows you to show the top/bottom items in your analysis. These will dynamically refresh as you interact with filters or update the data.
Where to from here?
Learn more about the Modify menu.