Playground I: FIXED and EXCLUDE

The first playground we will build will be for the purpose of exploring two of the three LOD functions: FIXED and EXCLUDE. We will use a set of parameters and associated calculated fields to efficiently explore how these functions work.

Exercise: exploring Fixed and Exclude and setting up the workbook

Much of the groundwork for this exercise has already been completed in the workbook associated with this chapter. If you do not have ready access to the workbook, you should be able to construct a similar one by referencing the following information.

Inspecting the worksheet and initial setup

...