Step 1: On the top right corner of the page, click on visualization under properties. Click on the Tree List icon under properties. 

Step 2: Drag and drop the required columns in dimension and measure. The data is represented in the form of a Tree List Chart.

Step 3: Locate the “Tree List” option under properties. Here, you can select the dimensions that you want to be in a separate column. 

Step 4: There are several other options that are available under tree list like “Collapse Column by Default, Parent Column Collapse, Hide Aggregate on Collapse, Disable Parent Collapse”. 

Step 5: You can toggle the collapse columns on default option. What this does is that all the columns of the tree list remain in a collapsed position. 

Step 6: If you want to show only the parent row of the tree list, then click on the parent column collapse toggle.

Step 7: You can also hide the aggregate total of the child that is displayed next to the parent. Toggle the Hide Aggregate on Collapse toggle. 

Step 8: To show the aggregate total next to the child, toggle the Hide Aggregate on Collapse toggle off. 

Note: The collapsed column aggregate toggle needs to be toggled on for Step 7 & Step 8 to give results.

If you do not want to close/ open the parent accordion and wish to freeze it, click on the Disable Parent Collapse toggle. The accordion will not be clickable.