This view displays the sales in a nested table as a function of year, region, and customer segment. Additionally, the data are color-encoded by product category. You can create the view with the following procedure.
-
Place the Order Date and Region dimensions on the Columns shelf.
The date is automatically aggregated by year, and headers are created for each dimension with labels given by the dimension member names.
-
Place the Sales measure and the Customer Segment dimension on the Rows shelf.
The measure is automatically aggregated as a summation, and an axis is created with a label given by the field name. Headers are created for the dimension with labels given by the dimension member names.
-
Place the Product 1 - Category dimension on the Color shelf.
Placing a dimension on the Color shelf separates the marks according to the members in the dimension, and assigns a unique color to each member. The color legend displays each member name and its associated color.
The view is shown below.
