GROUPANY

Syntax

GROUPANY(<any>)

Description

Returns an arbitrarily selected value contained in the group. The selection process is not completely random, but you can't influence which value is selected. This function used to be called GROUPFIRST and has been renamed GROUPANY in version 1.4.

This is an aggregate function. 

Example

Given the following data:

First create a group, e.g. GROUPBY(#RawData!Customer_).

Then use GROUPANY(#RawData!Item), and an arbitrary value from that column appears.