Create pivot tables to analyse your data

Create pivot tables to analyse your data

Create a pivot table in sheet

To create a pivot table:
  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.

Edit an existing pivot table

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

Alternatively, move your selection to the Pivot table. Click on the contextual pivot table side pane, and edit the table.

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

To 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

To view the total:
  1. Click on the pivot table.
  2. Go to Customize in the contextual menu on the right.
  3. Turn on/off the Subtotal, Column Grand Total and Row Grand Total as per your necessity. 

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.

    Zoho DataPrep Personalized Demo

    If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.

    Zoho CRM Training

      Create, share, and deliver

      beautiful slides from anywhere.

      Get Started Now

              Zoho CRM Training Programs

              Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.

              Zoho CRM Training

                  Zoho SalesIQ Resources

                      Zoho TeamInbox Resources

                                Zoho DataPrep Resources

                                  Zoho DataPrep Demo

                                  Get a personalized demo or POC

                                  REGISTER NOW

                                    Design. Discuss. Deliver.

                                    Create visually engaging stories with Zoho Show.

                                    Get Started Now

                                                          • Related Articles

                                                          • Working with pivot charts

                                                            Pivot charts, like the name suggests, lets you visualize the data while simultaneously letting you slice and dice the data just like a pivot table. Like any other chart, you can even customize how a pivot charts looks.   Creating a pivot chart Click ...
                                                          • How to create data validation?

                                                            Create a data validation for cells To create data validation: Click Data > Data Validation. You can choose the required range to apply data validation from the dialog shown below. The options that are available include the following: Decimal number, ...
                                                          • Get AI recommended charts and pivots for your data

                                                            What is Zia? Zia, Zoho Sheet's Artificial Intelligence recommends personalized charts and pivots for your data. You can even ask queries in natural language about the data to Zia. Look for Zia's suggestions Click on the Zia icon on the bottom right ...
                                                          • Create a new blank spreadsheet

                                                            To create a new blank spreadsheet, open the app and follow these steps: In the listing page, tap the + icon in the bottom bar. Choose the Blank Spreadsheet option from the listed gallery.
                                                          • Create and customize charts to visualize data

                                                            Create a chart To create a chart: Select the range for which you need a chart. Click Insert > Chart. A chart is generated to best represent the data. Click the chart to open the contextual side panel. Edit or modify the chart type, design, title, ...



                                                          Watch comprehensive videos on features and other important topics that will help you master Zoho CRM.


                                                          Download free eBooks and access a range of topics to get deeper insight on successfully using Zoho CRM.


                                                          Sign up for our webinars and learn the Zoho CRM basics, from customization to sales force automation and more.

                                                          CRM Tips

                                                          Make the most of Zoho CRM with these useful tips.

                                                            Zoho Show Resources