Creating a pivot table

Top  Previous  Next

To add a pivot table, click on the Add pivot table button.

 

sda_pivot01

 

 

Next, select the columns you want to use in your pivot table.

 

pivot_03

 

Click on the (copy) item if you want to add a duplicate of an existing column to your pivot table.  You may want to do this if you want to summarize or group the data in a different way to the existing column.

 

Uncheck the Use data option for columns you don't want to use in your pivot table.  The more columns you have, the longer it will take to recalculate the summaries.  You can always add more columns later.

 

The Area option specifies where you want the column to be initially positioned.  See this topic on what each area represents.  You can always change the positions of columns in the pivot table.

 

For Summary type and Summary variation, see this topic for the description of those items.  You can always change these values later.

 

For Grouping type and Group interval, see this topic for the description of those items.  You can always change these values later.

 

The Column label value is the text you want to display for the column.