Practical examples

Before concluding this chapter, let's go over two quick examples that are based on questions that were used in real exams.

Moving average

Using Global Superstore, as of June 2012, what is the sum of the sales of the previous twelve months and the following twelve months, excluding the current month?

To do this, we start by plotting SUM(Sales) by Month(Order Date). Then we create a quick table calculation for Moving Average by right-clicking the pill.

To add Month(Order Date) as shown in the following screenshot, you can drop Order Date in rows, then click on the pill menu for the second Month option (the one that reads a month and year) and change the pill to Discrete (in the pill menu).

The default...