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 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.