Creating a treemap

When you configure a treemap, you must define which hierarchy to show, as well as what should determine the sizes and color of the different rectangles.

Before you begin

See Treemap for a description of the concept.

Procedure

On the authoring bar, click Visualization types to open the flyout.
Drag the Treemap visualization type to the desired position on the analysis page.
A suggestion of a treemap is presented.
On the Hierarchy axis, select the columns to include in the hierarchy. Start with the top level.

The order specified here determines the order of the levels in the treemap hierarchy. For example, Continent - Country - City, where Continent will be the highest level, and City the lowest.

If needed, you can change the axis settings to determine which combinations of categories to show.

Tip: Instead of adding separate columns to set up a treemap hierarchy, you can use a previously defined hierarchy. To learn more about creating hierarchies, see Defining hierarchies.
On the Size axis, select by which column the rectangles should be sized, and select which type of aggregated value to show for the selected column.

Note: Because items with negative values have no size and cannot be shown, you must not size by a column that could contain negative values.
On the Color axis, select by which column the rectangles should be colored and select which type of aggregated value to show for the selected column.

Example

The data table below lists how much money different customers have spent at four different store departments. Assume you want to find the "top" male and female customer at the Toys department.
Data table for treemap.

The treemap settings below give you the answer.
Treemap finding the "top" male and female customer at the Toys department.

Customer ID SSMM55005 is the woman who spent most money, and SSMM55091 is the man, because these customers' rectangles are the largest in the female and male branches respectively.

Maybe these two customers are the "top" customers at the Clothing department as well? To find out, change the column on the Color axis to Clothing to see if these rectangles have the darkest color.
Treemap, further investigation.

It seems other customers are more interested in clothing than the two customers who spent the most on toys.