Create pivot tables to analyse your data | Zoho Sheet Help Guide

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.



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

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. 


Hide errors and repeat unique labels

To 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.
Errors in a pivot table occur if incorrect formula or calculation errors exist in the source data. To hide errors in a pivot table:
  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.



    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
      Redefine the way you work
      with Zoho Workplace

        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 Sign now offers specialized one-on-one training for both administrators and developers.

            BOOK A SESSION








                                You are currently viewing the help pages of Qntrl’s earlier version. Click here to view our latest version—Qntrl 3.0's help articles.




                                    Manage your brands on social media

                                      Zoho Desk Resources

                                      • Desk Community Learning Series


                                      • Digest


                                      • Functions


                                      • Meetups


                                      • Kbase


                                      • Resources


                                      • Glossary


                                      • Desk Marketplace


                                      • MVP Corner


                                      • Word of the Day


                                        Zoho Marketing Automation

                                          Zoho Sheet Resources

                                           

                                              Zoho Forms Resources


                                                Secure your business
                                                communication with Zoho Mail


                                                Mail on the move with
                                                Zoho Mail mobile application

                                                  Stay on top of your schedule
                                                  at all times


                                                  Carry your calendar with you
                                                  Anytime, anywhere




                                                        Zoho Sign Resources

                                                          Sign, Paperless!

                                                          Sign and send business documents on the go!

                                                          Get Started Now




                                                                  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







                                                                                            You are currently viewing the help articles of Sprints 1.0. If you are a user of 2.0, please refer here.

                                                                                            You are currently viewing the help articles of Sprints 2.0. If you are a user of 1.0, please refer here.



                                                                                                  • 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, ...
                                                                                                  • How to create and manage data connections?

                                                                                                    Data connections Data connections help you pull in data from URLs, feeds, and other Zoho applications powered by Zoho Flow. To import data from a URL: Click on the Data > Data Connection > Create Connection. Choose to import from Feeds/URLs. To ...
                                                                                                  • Create a table

                                                                                                    What is a Table? Table is one of the best spreadsheet tools to group and analyze data swiftly. Format your data into tables for better visualization! To create a table: Go to Format > Table. Select a table style from the list of options. Mention the ...
                                                                                                  • Use Zia for better data analysis

                                                                                                    Zia is an AI assistant that when given a particular set of values will recommend charts and pivot tables to make data analysis easier. To get recommendations from Zia: Select the desired range of cells. Tap Insights with Zia under the Data menu. The ...
                                                                                                    Wherever you are is as good as
                                                                                                    your workplace

                                                                                                      Resources

                                                                                                      Videos

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



                                                                                                      eBooks

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



                                                                                                      Webinars

                                                                                                      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