Symptom
This article explains the different Pivot Measure Functions for date values while creating Pivot reports using the Online Report Designer:
Count
Distinct Count
First
Last
Minimum
Maximum
Environment
SAP SuccessFactors HCM Suite
Resolution
Let us consider the following values to be the underlying list report’s data:
1/5/2017
1/2/2017
1/12/2017
1/2/2017
1/7/2017
Count:
Calculates the number of records
Output : 5
Distinct Count:
Calculates the number of distinct records:
Output: 4
First:
Fetches the first record.
1/5/2017
Note: This might be random, unless an explicit sorting rule has been applied in the underlying data source (List Report / Database)
Last:
Fetches the last record.
1/7/2017
Note: This might be random, unless an explicit sorting rule has been applied in the underlying data source (List Report / Database)
Minimum:
Fetches the Record with the minimum value:
1/2/2017
Maximum:
Fetches the Record with the maximum value:
1/2/2017
Keywords
Pivot, Report, Designer, Measure, Function, Measure, First, Last, Min, max, count, aggregate , KBA , LOD-SF-ANA-ORD , Online Report Designer , How To