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:

Customer_	Name	Item
2535	Jon	Zamioculcas
2888	Mike	Spider Lily
2535	Jon	Datura
2535	Jon	Dahlia
5788	Jon	Snapdragon
2888	Mike	Marguerite
2535	Jon	Windflower
2888	Mike	Elephant's Ear
2535	Jon	Chinese Evergreen
5788	Jon	Begonia
5788	Jon	Starfish Plant
2535	Jon	Hare's Foot Fern
2535	Jon	Venus Flytrap
3545	Monique	Red Flame Ivy

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

Customer_
2535
2888
3545
5788

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

Customer_	GROUPANY returns
2535	Zamioculcas
2888	Spider Lily
3545	Red Flame Ivy
5788	Snapdragon

Browser not supported