Loading

How to calculate the 2nd oldest order date

Data pubblicazione: Apr 13, 2024
Operazione

How to calculate the second oldest order date

Fasi
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)
 
Numero articolo Knowledge

001458470

 
Caricamento
Salesforce Help | Article