Inventory

Data Table

1. Add Product Line to the Selected Columns:

• From the Categories/Columns list, expand Products.

• Click Product Line.

• Click the top arrow to move Product Line to the Selected Columns area.

1. Repeat the previous step to add Products -> Product Name, Inventory and Cost > Quantity In Stock, and Inventory and Cost -> MSRP to the Selected Columns area.

2. To ASC Sort by Product Line and create the table:

• From the Categories/Columns list, click Product Line.

• Click the bottom arrow to move Product Line to the Order By area.

• Click OK.

1. In the Title text box, type Inventory Table, and then click Apply.

Chart

1. In the Untitled 2 header, click Insert Content, and then click Chart.

2. From the Select Data Source dialog, click Inventory, and then click OK.

1. Add columns to the Selected Columns:

• From the Categories/Columns list expand Products.

• Click Product Line.

• Click the top arrow to move Product Line to the Selected Columns area.

• Expand Inventory and Cost.

• Click Quantity in Stock.

• Click the top arrow to move Quantity in Stock to the Selected Columns area.

• Click MSRP.

• Click the top arrow to move MSRP to the Selected Columns area.

1. Add a condition for Product Line and open the Chart Designer:

• From the Categories/Columns list, click Product Line.

• Click the middle arrow to move Product Line to the Conditions area.

• From the Comparison drop-down list, select begins with.

• In the Value column, type M.

• Click OK.

1. To create the chart, complete the following fields in the Chart Designer window, and then click OK: