Tree Reports

A Tree is a hierarchical view of tabular data. Unlike Summary reports, a tree enables you to expand and collapse levels of the hierarchy.

In the above example, the tree is displaying a hierarchy of Deal Status -> Current Stage.

You can expand and collapse folders to hone in on certain data within the hierarchy.

Normally, you'll select some combination of fields to represent the columns of the tree table. Alternatively, you can select a grouping and a measure, and the table will automatically add a column showing the measure broken out by each value found in the grouping. If a filter is present in the report on that grouping, it will use that filter to restrict what's shown. To accomplish this, after you've selected Tree as the report type, click on the Customize link next to the Report Type button and choose 'Dynamic Column Tree'. Define your hierarchy, then choose a grouping and a measure to populate the rest of the report as shown below:

You can also create a cascading tree if your data has a set of parent/child relationships. For example, project management tools often have parent task -> subtask relationships. You can use cascading trees to display subtasks nested underneath their parent tasks.

To get started, choose a report type of Tree. Click on the "Customize" link and choose Cascading Tree as the subtype. You'll build your tree as normal, but you'll need to specify the parent ID and row ID fields used in matching up parent/child values. For example, with Teamwork, you'll specify the cascade parent as Task Parent ID and the cascade ID as Task ID, as shown below: