Building a Report

To understand how the treemap page works and what it displays, let’s build an example report.

Into the Levels designer drag the levels “Product.Category” and “Product.Subcategory”. You will get a diagram constructed of the same number of rectangles as the number of elements in the “Subcategory” level:

Move the grouping pointer to the right to group up the elements by product categories:

As you can see all the rectangles are grouped by categories. But all the rectangles still have the same area because we did not set the measure determining the area of elements. Drag the “Reseller Gross Profit” measure into the “Size” designer:

Now the area of each rectangle became proportional to the corresponding value of “Reseller Gross Profit” measure for the element. Negative values are hatched.

Drag the measure “Reseller Gross Profit Margin” into the “Color” designer:

The two colored gradient highlighting will be added, that will show us how large (more green color) or small (closer to red) is the profit from selling the products of each category.

You can change the highlight rule by pressing the button that is showing the gradient:

The window for setting up the gradient will appear, exactly the same as you could see when setting up the gradient for highlighting in the table:

And finally, using “Context” designer, let’s bound the data to show only the sales in the territory of “United States”. For that purpose, add the “Geography” hierarchy into the context and select only the element “United States” there:

Thus we created the report, showing the profit from selling products of different categories in “United States”. Every product subcategory is shown with the rectangle on the diagram. The area of each rectangle is proportional to the value of gross profit from selling the products of corresponding subcategories. And the color of a rectangle depends on the value of that profit in percents. The closer color is to green the bigger is the value, while closer to red, means the value is smaller: