The UnCrosstab Filter
The UnCrosstab Filter element is used with datalayer elements to "un-pivot" or "reverse pivot" rows of data into columns of data. It converts one row of multi-column data into multiple rows, each with a single data value.
The following topics discuss the UnCrosstab Filter element:
About the UnCrosstab Filter
The UnCrosstab Filter element is available for use with all datalayer elements and is the functional opposite of the Crosstab Filter element.
In operation, the element basically converts each row in the datalayer, each of which has multiple columns, into multiple rows, each of which has one value column.
It's a little easier to understand the filter's actions when you can see the effect limited to one row, in a Data Table, as shown above. This "un-pivot" action normalizes the data on the fly and, among other applications, can be really useful when having to work with data imported from spreadsheets.