Welcome to Catalog Tips
Search more than 200 articles to learn more about creating and automating your product catalogs
Tip: Start typing in the input box for immediate search results.
GROUPCROSSTABLEVALUE – Get cross table cell content
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.