Pivot

Pivot Table makes it super easy to not only summarize (aggregate) data but also spot outliers or patterns quickly by using color. And, just like any other visualization (chart) types, you can share it with reproducible data preparation steps simply by clicking a button and start having a conversation around the data.

Column Assignments

• Row - Assign a column you want to show at Row Headers. If it's a Date / Time column assigned, you can select the aggregation level such as Month, Week, Day, etc. You can assign multiple columns to Row.

• Value - Assign a column you want to show at the value area. You can assign multiple columns to Value. If a numeric column is assigned, you can set the aggregation function such as Sum, Mean (Average), etc. to aggregate the values. If it is a non-numeric column, you can set a count-based aggregation function such as Unique Count or a function to pick one of the values in the group such as "First (First Row)".

• Column - Assign a column you want to show at Column Headers. If it's a Date / Time column assigned, you can select the aggregation level such as Month, Week, Day, etc.

• Total - You can choose what type of totals to show. The following options are available.

  • None

  • Totals Only

  • Subtotals Only

  • Totals and Subtotals

• Total Target - You can choose total targets to show. The following options are available.

  • Both Column & Row - It shows totals for rows and columns.

  • Only Row - It shows totals for rows.

  • Only Column - It shows totals for columns.

Formatting Columns

You can format each Row Header and Value column. You can access the Column Format dialog by selecting the "Formatting" menu in the column menu next to the column name dropdown. See Column Configuration Dialog for mode details.

Color Assignment

You can quickly apply the color formatting from the "Color Assignment" column menu. You can configure the formatting details in the Column Configuration Dialog.

Fit to Screen

You can fit the table to the chart viewing area by the "Fit to Screen" option in the chart property dialog. See Fit to Screen (Table) for more details.

Window Calculation

You can assign Window Calculations for each column at Value. See Window Calculation for more details.

Visual Sort

You can sort by the column by clicking the column header. Note that the sort happens only for the rows fetched.

Category

You can categorize numeric values inside the chart. See Category(Binning) for the detail.

Limit Values

You can use Limit Values to filter the categories by the aggregated values. See Limit Values for the detail.

'Others' Group

If you have many categories, you can reduce the number of categories by changing some category names to 'Others' using the 'Others' Group feature. See 'Others' Group for the detail.

Custom Function

You can use the Custom Function feature to define your own aggregation function at Value. See Custom Function for the detail.

Missing Value Handling

You can use the Missing Value Handling feature to control missing values. See Missing Value Handling for the detail.

Total Setting

Calculation Target for Total Calculation

You can choose how to calculate the totals/subtotals at the Calculation Target in the Setting dialog for total.

• Data After Aggregation: Totals and subtotals are calculated based on the cell values in the Pivot Table which are already aggregated.

• Data Before Aggregation: Totals and subtotals are calculated based on the raw data before any aggregations.

Position

You can choose which side to show the Row total. The following options are available.

• Right (Default)

• Left

Show Detail

You can show the detailed data underlying the chart by clicking the value text. See Show Detail for the detail.

Layout Configuration

Take a look at Layout Configuration on how to configure the layout and format.