The objectives of the following worksheet displays those customers who made purchases in the last 2 days of 2013, and the associated absolute as well as relative sales of the month of December.
In the following table, notice in the results how LOOKUP behaves directional whereas TOTAL is non-directional. Follow the steps in order to do so:
- In the workbook associated with this chapter, navigate to the Lookup/Total worksheet.
- Drag Customer Name and Order Date to the Rows shelf. Set Order Date to Month/Day/Year discrete.
- Place Order Date on the Filters shelf and choose to view only December 2013.
- Create the following calculated fields:
Name |
Calculation |
Lookup Intervening Time |
DATEDIFF(day,LOOKUP(Max([Order Date]),0), ... |