Grouping data

GROUPCROSSTABLEVALUE – Get cross table cell content

133 views June 1, 2018 admin 0

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.

See also

GROUPCROSSTABLEHEAD

Was this helpful?