# 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.

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.