Exercise: practical EXCLUDE

In this exercise, we will create two worksheets using the Superstore dataset. Each will calculate the percentage of sales generated by each city in a region. In the first solution, we will use LOD calculations. In the second solution, we will use a data blend.

Exercise steps part I: solving using an LOD calculation

Follow along the exercise steps:

1. Select the Practical Exclude worksheet.
2. Select the Superstore dataset.
3. Create the following calculated fields:

Region Values	% Per Region LOD
{ EXCLUDE [City],[State]:ZN( SUM([Sales]) )}	SUM([Sales])/SUM( [Region Values] )

4. Place Region and City on the Rows shelf.
5. Place Measure Names on the Columns shelf and Measure Values on the Text...