Building the Report

Let’s build the report that will show the values of “Reseller Sales Amount” and “Reseller Gross Profit Margin” for product subcategories sold in Australia. To do that, drop the “Reseller Sales Amount” measure on X axis, and “Reseller Gross Profit Margin” – on Y axis. To the “Details” designer drag the “Subcategory” level from the” Product Categories” hierarchy:

Drop the “Geography” hierarchy into the context and select the element Australia there:

You will get the following report:

Every circle on the diagram corresponds to the element from the selection made in Details designer, in our case it corresponds to one product subcategory. If you drag the mouse over the circle, you’ll see the hint, showing, which element this circle corresponds to. On the axes you can see the values corresponding to the selected element.