Exercise: practical INCLUDE

In this exercise, we will create a worksheet that displays the following:

• Total sales per region
• The average of total sales across all regions
• The average of total sales across all states in each region

Using an LOD calculation to display these values is pretty straightforward. Prior to 9.0, however, such a worksheet could be rather convoluted. Let's explore.

Exercise steps part I – solving using an LOD calculation

Follow along the exercise steps:

1. Select the Practical Include worksheet.
2. Select the Superstore dataset.
3. Create a calculated field named Per State INCLUDE with the following code:

{INCLUDE [State]:SUM([Sales])}

4. Drag Region to the Columns shelf, SUM(Sales) to the Rows shelf...