Following, we will setup a worksheet with which we can practice the INCLUDE Level of detail calculations.
- Open the workbook associated with this chapter and navigate to the Exploring Include worksheet.
- The parameters and calculated fields named 1st Dim, 2nd Dim, 3rd Dim, and 4th Dim created in the previous exercises are also utilized for this worksheet.
- Right-click on the 1st Dim parameter and choose Duplicate.
- Rename the duplicate Choose Included Dims.
- Create a new calculated field named Case Include with the following code:
CASE [Choose Included Dims] WHEN 1 THEN AVG({INCLUDE [Category]: SUM([Sales])}) WHEN 2 THEN AVG({INCLUDE [City]: SUM([Sales])}) WHEN 3 THEN AVG({INCLUDE [Country]: SUM([Sales])}) ...