Previous Value

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:

  1. In the workbook associated with this chapter, navigate to the Previous Value worksheet.
  2. Create the following calculated fields:



Next Year Goal Prv_Val

PREVIOUS_VALUE(SUM([Sales])) * 1.05

Next Year Goal Lkup

LOOKUP(SUM([Sales]),0) * 1.05

  1. Place Order Date on the Rows shelf.
  2. Double-click Sales and Next Year Goal Prv_Val to place ...

Get Mastering Tableau 2019.1 - Second Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.