Create a pivot table in sheet

1. Click Data > Pivot Table.
   
2. Choose the range of cells from which the table is to be constructed and where the table must be created
   
3. Drag and drop the fields into the desired positions in the Pivot Table Builder and click Generate.
   
4. Use Reset to remove all the fixed fields.
   

If you wish to copy the pivot table's data (filtered or unfiltered) to a new sheet, right click on the cells of the desired pivot table with numerical values and select Show Details. Alternatively, you can double-click on the cells of the desired pivot table with numerical values to copy the data (filtered or unfiltered) to a new sheet.

Edit an existing pivot table

1. Right click on the pivot table to be edited.
   
2. Select Builder.
   
3. Make the desired changes and click Generate.
   

Move a pivot table across sheets

To move a pivot table:

1. Right click on the pivot table to be moved.
2. Select Move from the contextual menu.
3. Choose the destination sheet i.e. new sheet or an existing sheet and click OK.
   

Change the style of a pivot table

1. Click on the pivot table.
2. The Pivot Table context menu opens on the right.
3. Select the desired Table Styles, Color Schemes and click Generate.
   

View the subtotal of the data in a pivot table

Hide errors and repeat unique labels

1. Click on the pivot table you wish to repeat labels.
   
2. Go to Customize and turn on the Repeat Item Labels option.
   

1. Click on the pivot table you wish to hide errors.
   
2. Go to Customize and turn on the Hide Errors option.

With the Repeat Item Labels option, you can also repeat unique date fields in the pivot table as shown here.

Group and ungroup data in a pivot table

To group the data in a pivot table:

1. Right-click on the pivot table and click Group.
   
2. Edit the minimum, maximum, and the range values as needed. Click OK.
   
3. To ungroup the data in a pivot table, select Ungroup from the right-click menu.
   

 

Delete a pivot table

To delete a pivot table:

Right click on the pivot table and click Delete, or select the table and go to Custom > Delete in the Pivot Table context menu on the right.