Table of Contents
Overview
This Custom Field is used to determine the value that should appear at each intersection of the table. This function should be used in conjunction with the ‘GROUPCROSSTABLEHEADER’ function to determine the cross references.
Syntax
GROUPCROSSTABLEVALUE(‘GroupPath‘,’SortField‘,’CrossField‘,’SearchField‘,’FieldValue‘,’EmptyValue‘)
| Element | Description |
|---|---|
| GroupPath | Group path, delimited by colons |
| SortField | Field by which to sort |
| CrossField | The field used for each table column |
| SearchField | Field to look up. |
| FieldValue | Field to use in table. |
| EmptyValue | The value to use if search returns no result. |
Example
Refer our separate “How to create cross-tab tables on the fly using EasyCatalog panel data” guide.