PIVOTLONGER

Description

The PIVOTLONGER function transforms a table, moving some of its columns to rows.

Usage

PIVOTLONGER (<Table Expression>, <Column Selector Expression>, <Category column name>, <Value column name>)

The PIVOTLONGER function evaluates to a new table.

Examples

Pivoting disaggregate fields into rows

If you have a form with aggregate values by gender, it may be useful pivot this longer:

PIVOTLONGER(schools, COLUMNS(Girls, Boys), "Sex", "Count")
Next item
Record context