Index:
1. What is a Pivot Table?
2. When to use Pivot Table?
3. Step By Step Guidance with DataInsider
1. What is a Pivot Table?
Pivot Table presents data in a tabular format, this type of table allows you to have dimensions displayed on both rows and columns.
Pivot Table is much more powerful than a regular table chart as not only do you have a wider insight of your data but you can also actively sorting data order right on the chart.
![](https://static.wixstatic.com/media/31ceee_7b7f2f8c1fd64884b170f71eb7e48976~mv2.png/v1/fill/w_980,h_611,al_c,q_90,usm_0.66_1.00_0.01,enc_avif,quality_auto/31ceee_7b7f2f8c1fd64884b170f71eb7e48976~mv2.png)
2. When to use Pivot Table?
A Pivot Table is a great choice for displaying aggregated data since this type of visualization combining multiple dimensions and measure.
3. Step By Step Guidance with DataInsider
Desired table: A pivot table that displays the number of products sold by customers' civility title and app-having.
Step 1. Drag hasAnyApp to Columns
Step 2. Drag civilityTitle to Rows
Step 3. Drag productsSold to Values
![](https://static.wixstatic.com/media/31ceee_74e3e2b65abe4025b43ee33ae9038466~mv2.gif/v1/fill/w_980,h_456,al_c,usm_0.66_1.00_0.01,pstr/31ceee_74e3e2b65abe4025b43ee33ae9038466~mv2.gif)
With DataInsider, you can easily create multi-dimensional tables with Pivot Table. A Pivot Table provides a deeper insight of the data in comparison to a regular table.
Comments