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.

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.

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

2. Aggregating numeric measures

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

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

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.

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.