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