GROUPMEDIAN

Syntax

GROUPMEDIAN(<number>)

Description

Returns the medium of all values in a group.

This is an aggregate function. 

Example

Given the following data:

First create a group using GROUPBY(#RawData!Groups)

Then use the GROUPMEDIAN(#RawData!Participants), and the result is the medium number of the column in relation to the GROUPBY() column.