Pivot table

Pivoting dimensions and measures

Use the Pivot Table option to easily re-structure your dimensions and measures and select the aggregation for totals and subtotals.

Pivot table interface

1. Converting rows into columns

You can pivot row and column dimensions by dragging them into the respective buckets. Let's look at how to convert the Region column dimension into a row dimension.

Region column dimension

Drag the Region dimension from the Columns bucket to the Rows bucket to pivot the columns into rows.

Column to row conversion

2. Aggregating numeric measures

When you enable totals and subtotals, you can also specify the type of aggregation to apply: sum/average/minimum/maximum.

Aggregation type

In this query, we've applied summation for the Profit measure and average for the Sales measure.

Aggregated measures

3. Converting text dimensions into measures

You can convert text dimensions into measures and vice versa. Drag the dimension into the Values bucket to convert it into a measure.

4. Concatenating text measures

Use the Concat option to aggregate strings from multiple rows into a single string, with a delimiter of your choice. For instance, you can concatenate all the accounts under a particular segment and analyze data at a higher granularity, without losing any information.

Concatenating text measures with a delimiter

Individual accounts are rolled up at Account type level, providing a concise summary of the dataset. The aggregated rows can then be consumed in other destination visuals.

Aggregated text measure