SAP Knowledge Base Article - Public

2482263 - What do the different Pivot measure functions for date values do?

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

Product

SAP SuccessFactors HCM suite all versions