Loading

How to calculate the 2nd oldest order date

Udgivelsesdato: Apr 13, 2024
Opgave

How to calculate the second oldest order date

Trin
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)
 
Vidensartikelnummer

001458470

 
Indlæser
Salesforce Help | Article