From the course: Tableau 10: Mastering Calculations

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Look up values using PREVIOUS_VALUE and LOOKUP

Look up values using PREVIOUS_VALUE and LOOKUP - Tableau Tutorial

From the course: Tableau 10: Mastering Calculations

Start my 1-month free trial

Look up values using PREVIOUS_VALUE and LOOKUP

“

- [Instructor] In business, it's often important to compare value such as a month's sales to the previous value from that dataset. You can create a table calculation to do that using the previous value function. If you want to look up other values such as those two or three table rows away, you can use the lookup function and specify the distance you want to move. In this movie, I will show you how to create these table calculations. My sample file is the previous workbook, and you can find it in the chapter 7 folder of the exercise folders collection. I have monthly order total data for my hotel which orders supplies, and what I want to do is to determine the difference between one row, in this case February of 2015 and the previous row. To do that, I can create my table calculation so I'll go to the marks card, hover the mouse pointer over the order total pill, click the down arrow, and click Add Table Calculation. The table calculation dialog box appears, and I want to find the…

Contents