q Expand or collapse sections of the hierarchy by clicking on the to expand, and to collapse.
Additionally, the right click context menu includes options for Expand All and Collapse All
However, when the workbook designer turns on the Virtual Mode option in the Table Settings, the table will be in a flat mode and the expand and collapse options will no longer be available.
Expanding and collapsing can also be done by selecting specific items to display. Right-click on the item and then select Show <Item> on the context menu.