The second sheet: Product Details

In the second sheet you will make a bar chart and treemap that focus on products. Then you will add filter panes so you can filter by date and region.

You will start your work in standard edit mode. Once you create your visualizations you will use advanced edit mode to customize them.

Adding the bar chart

The next visualization is a bar chart showing the Top Sales. Make sure that Advanced properties is toggled off.

Do the following:

1. In the assets panel, go to Fields, and drag the Product Group field to the sheet and add it as a dimension.

2. Add Sales and Margin as measures.

   By default, the measures are grouped when you add a second measure to a bar chart.

3. Under Properties > Visualizations, select .

4. Under Presentation > Labels, select the Show value labels check box.

Adding the treemap

Treemaps display hierarchical data by using nested rectangles. Use a treemap when space is constrained and you have a large amount of hierarchical data that you need to get an overview of. Treemaps should primarily be used with values that can be aggregated.

For more information, see Treemap.

In this treemap you will create a product hierarchy.

Do the following:

1. Click below the bar chart to add a new visualization.

2. Add Product Group, Product Type, and Item Desc as dimensions.

3. Add Sales as a measure.

4. Under Properties > Visualizations, select .

5. Under Presentation > Labels, add the title: Product Treemap.

Customizing your charts in advanced edit mode

Now that all the visualizations have been created, you will switch to advanced edit mode to customize them. In the top right, toggle on Advanced options.

Customizing the bar chart

Do the following:

1. Select the bar chart.

2. Go to Sorting. Order your dimensions and measures like this:

   1. Sum(Sales)

   2. Sum(Margin)

   3. Product Group

3. Click Sum(Sales). Set Sorting from Auto to Custom. Select Sort numerically.

   Your bar chart is now ordered from best selling to worse selling.

4. You can add expressions in chart titles. Go to Appearance > General. Find Title, and click on .

   The expression editor opens.

5. This expression will resolve to show total sales:

   ='Total Sales: $'& Round(Sum(Sales)/1000000, 0.1) & 'M'

Customizing the treemap

Do the following:

1. Select the treemap.

2. Under Appearance > Colors and legend, set Colors from Auto to Custom.

3. Select By measure in the list.

Adding the filter panes

The purpose of the filter panes is to filter out a limited data set, which you can analyze and explore.

For more information, see Filter pane.

You will now reuse the Period filter pane and the Region filter pane that you saved as master items.

Do the following:

1. Resize the bar chart and treemap so that there is space on the left for two filter panes.

2. In the assets panel, click to open Master items.

3. Click Visualizations.

4. Drag the filter pane Period to the sheet and resize it.

5. Drag the filter pane Region to the area below Period and resize it.

This sheet is complete. In the assets panel, click Sheets and select Customer Details to move to that sheet.