Loading

How to calculate the 2nd oldest order date

Дата публикации: Apr 13, 2024
Задача

How to calculate the second oldest order date

Действия
The steps below is to calculate the 2nd oldest order date for each customer using sample workbook.

1. Connect to Sample -Superstore
2. Drag [Customer Name] to Rows

-Calculate 2nd oldest Order Date-
3. Create a new Calculated Field like the following.
    Name : 2nd Order Date
    Calculation : { FIXED [Customer Name]:
                         MIN(IF [Order Date] > { FIXED [Customer Name] : 
                         MIN([Order Date])} THEN [Order Date] END)}
4. Right-click and drag [2nd Order Date] to Rows  ->  Select MDY(2nd Order Date)
 
Номер статьи базы знаний

001458470

 
Загрузка
Salesforce Help | Article