Page tree
Skip to end of metadata
Go to start of metadata

Syntax

GROUPBY(any)

Description

This function creates groups based on a key (a column) selected by the user. These groups are then used to sort the results of either aggregate or group series functions. It is possible to create sub-groups by using this function again on another key from the same workbook sheet. The rows for each group series are highlighted when the GROUPBY function is complete.

Example

Given the following data:

Customer_NameItem
2535JonZamioculcas
2888MikeSpider Lily
2535JonDatura
2535JonDahlia
8654<null>Windflower
5788JonSnapdragon
2888MikeMarguerite
2535JonWindflower
2888MikeElephant's Ear
2535JonChinese Evergreen
5788JonBegonia
5788JonStarfish Plant
2535JonHare's Foot Fern
2535JonVenus Flytrap
3545MoniqueRed Flame Ivy
8654<null>Starfish Plant
4587<null>Begonia

Use GROUPBY(#RawData!Name) to create initial groups.

Customer
<null>
Jon
Mike
Monique

Use GROUPBY(#RawData!Customer_) to create sub-groups.

CustomerCustomer_Number
<null>4587
<null>8654
Jon2535
Jon5788
Mike2888
Monique3545

Use a further group series or aggregation function to look at our results more closely (here use GROUPCOUNT to find the total number of orders per customer).

CustomerCustomer_NumberNum_Orders
<null>45871
<null>86542
Jon25357
Jon57883
Mike28883
Monique35451

Also see:

  • No labels