The objectives of the following worksheet are to return the aggregate value of sales for each year and set next year's sales' goal. Note that two options have been provided for determining next year's sales' goal in order to demonstrate how PREVIOUS_VALUE differs from LOOKUP. Also note that PREVIOUS_VALUE behaves directionally.
Let us have a look at the steps:
- In the workbook associated with this chapter, navigate to the Previous Value worksheet.
- Create the following calculated fields:
Name |
Calculation |
Next Year Goal Prv_Val |
PREVIOUS_VALUE(SUM([Sales])) * 1.05 |
Next Year Goal Lkup |
LOOKUP(SUM([Sales]),0) * 1.05 |
- Place Order Date on the Rows shelf.
- Double-click Sales and Next Year Goal Prv_Val to place ...