Loading

How to calculate the 2nd oldest order date

Date de publication: Apr 13, 2024
Tâche

How to calculate the second oldest order date

Étapes
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)
 
Numéro d’article de la base de connaissances

001458470

 
Chargement
Salesforce Help | Article