The pivot by feature provides an easy and powerful way to summarize data for
analytics. You can specify a column to use as a
categorical variable and the unique values to use. When the
data query is run, the
output table is summarized with the aggregations that you apply.
To use the pivot by
feature:
-
On the
Column
Editor tab, place your pointer in the
Pivot
By cell for the column to use as the pivot column. Click
the ellipsis button to select the pivot column and values.
-
In the
Pivot
Values dialog box, select the pivot by column. You can enter
search criteria in
Filter fields to
filter the column names.
The
following display shows an example of pivoting by three values in
the Product_Category column.
-
After the unique values for the column are loaded, select the
check boxes for the values to use in the summarization. Click
Apply.
Tip
TRP is specified as the label
for the Total_Retail_Price column. Look at the next display to see
how the label is used to create labels for the new columns.