Table of Contents
Overview
This Custom Field returns the number of unique instances of a fields content in a group
Syntax
GROUPCOUNTUNIQUE(‘Parent Category:Child Category’,‘Manufacturer’)
| Element | Description |
|---|---|
| ‘Parent Category:Child Category’ | Group path, delimited by colons |
| ‘Manufacturer’ | Field in which to count instances |
Examples
For the table below, GROUPCOUNTUNIQUE(‘Category1ID:Category2ID:CollectionID’) will return 2 as there are 2 distinct/unique CollectionID rows.
| Category1ID | Category2ID | CollectionID | ProductName | Price |
|---|---|---|---|---|
| 25 | 136 | 1924 | Apple | 9.99 |
| 25 | 136 | 1924 | Banana | 11.00 |
| 25 | 136 | 1965 | Cantaloupe | 48.95 |
| 25 | 136 | 1965 | Durian | 29.99 |