A pivot table is a table that displays statistics generated from a larger table that contains your “raw” data set. This pivot table may display counts, sums, averages and other statistics describing variability. It thus allows you to get an overview over thousands of data points within a few clicks.
This tool is quite powerful, it does not need much time to set up, but it requires that the data set is optimally organised in rows and columns, the data are arranged in categories, and the variables described in the header have unique labels. The efficiency of the pivot table thus relies on your ability to create a “clean” table.
This section is separated into several posts which show you:
- How to prepare a clean “flat table” that contains your data set,
- How to create a pivot table from the flat table,
- How to display several statistics in a pivot table.
- How to display a subset of a category in a pivot table,
- How to display statistics for a combination of parameters.
Fant du det du lette etter? Did you find this helpful?
[Average: 0]