Skip to Content

Chart types

Set up a pivot table

Cross-tab measures by row and column groups, and set the columns in Pivot Settings.

Group measures by rows and columns in one table.

Before you start

  • The metric is grouped: it has at least one dimension and a measure with an aggregate. Pivot Table does not show until then.

Steps

  1. Add the group fields to Dimensions, for example region and month.

  2. Add the values to Measures, for example sum(revenue).

  3. In the chart toolbar, select Chart type, then Pivot Table.

    Chart type picker in the metric builder with the Pivot Table tile highlighted
    Pivot Table in the Chart type picker.
  4. In the chart toolbar, select Pivot. The Pivot Settings panel opens at the side.

    Metric builder Query toolbar with the Pivot button highlighted
    Pivot is the first button in the Query toolbar for a pivot table.
  5. In Columns, choose the dimensions to group by. Check the preview after each change.

    Pivot Settings panel with Columns set to sales channel, highlighted
    Columns sets the dimensions that become column headers.
  6. Set the other options you need. See Pivot settings.

  7. Save the metric.

Pivot settings

SettingWhat it does
Show Row AggregatesAdds a total for each row group.
Dynamic Pivot columnsThe columns follow the values in the data.
ColumnsThe dimensions the table groups by.
Hide Measure ColumnsHides the measures you pick from the table.
Measure Columns OrderSets the order of the measure columns.

Settings for this chart

Select Appearance in the chart toolbar. A pivot table has two tabs, Appearance and Actions. On Appearance:

  • Number format
  • UI styling: header, text wrap, content font, dividers and borders.
  • Conditional formatting
  • Formatting

Drill down and Chart Click Actions do not work on a pivot table.

Next: change how the chart looks.