Grouping data

GROUPCROSSTABLEHEAD – Get cross table column heading

192 views June 1, 2018 admin 0

Overview

This Custom Field is used to determine the headers for each column when creating a cross-tab table automatically from data contained with an EasyCatalog panel. The value returned is used as a parameter in the GROUPCROSSTABLEVALUE function to determine the value to display in each table cell.

Syntax

GROUPCROSSTABLEHEAD(GroupPath,SortField,CrossField,n)

Element Description
GroupPath Group path delimited by colons. Limits the scope to the specified grouping.
SortField Field used to sort records by within the group. Determines the order that in which columns will appear.
CrossField The field used in each column of the table.
n The index number of the header (starts at 0).

Example

Refer our separate “How to create cross-tab tables on the fly using EasyCatalog panel data” guide.

See also

GROUPCROSSTABLEVALUE

Was this helpful?