Skip to main content
insightsoftware Docs insightsoftware Docs
{%article.title%}
Published:
Was this article helpful?
0 out of 0 found this helpful

Pivot

The Pivot is one of the available Display types. A pivot table is a summarization tool. Among other functions, a pivot table can automatically sort, count a total or give the average of the data stored in one table or spreadsheet, displaying the results in a second table showing the summarized data.

WC_display_pivot

The rows and columns in a Pivot are interactive. You can switch (pivot) from a summary of all to the individual values.

In the following example, we take a look at a Pivot. In this example, all the rows are collapsed and the underlying data is summarized in the table.

WC_pivot_example_2

If you want to take a closer look at the underlying data, you can expand a row. The table then shows a breakdown of the data in that row. You can also drill down to the raw data by clicking on an element in the pivot table (see Drilldown).

WC_pivot_example

The same applies to the columns in a pivot table. Pivots are powerful tools to quickly summarize large data volumes.

Related topics

Published:

Pivot

The Pivot is one of the available Display types. A pivot table is a summarization tool. Among other functions, a pivot table can automatically sort, count a total or give the average of the data stored in one table or spreadsheet, displaying the results in a second table showing the summarized data.

WC_display_pivot

The rows and columns in a Pivot are interactive. You can switch (pivot) from a summary of all to the individual values.

In the following example, we take a look at a Pivot. In this example, all the rows are collapsed and the underlying data is summarized in the table.

WC_pivot_example_2

If you want to take a closer look at the underlying data, you can expand a row. The table then shows a breakdown of the data in that row. You can also drill down to the raw data by clicking on an element in the pivot table (see Drilldown).

WC_pivot_example

The same applies to the columns in a pivot table. Pivots are powerful tools to quickly summarize large data volumes.

Related topics

For an optimal Community experience, Please view on Desktop
Powered by Zendesk