When you view a worksheet, you can choose what items show on rows and columns. This is useful when you only need to view certain line items for data analysis. Not showing an item will effectively hide it.
You cannot select items to show on an axis that has hierarchy filters applied to it.
In a nested axis with filters applied, you cannot select which items to show. In this case, a warning message displays in the Show / Hide panel.
To select items to show on a worksheet:
If you want to show all items on the worksheet, you can:
Disclaimer
We update Anapedia content regularly to provide the most up-to-date instructions.