GROUPMAX

Syntax

GROUPMAX(<number>)

Description

Returns the maximum values in a group. A GROUPBY() function must first be used in order to then find the maximum arguments of another column in relation to it.

This is an aggregate function

Example

Given the following data:

NameNumber
Ajay27087
Ajay55317
Alice14489
Ajay31310
Ajay57822
Ajay63855
Alice47640
Alice48979

First create a group using GROUPBY(#RawData!Name).

Name
Ajay
Alice

Then use GROUPMAX(#RawData!Number) to return the maximum values of the Number column.

NameMax_Number
Ajay63855
Alice48979