New Pivot Tables in Zoho Sheet

New Pivot Tables in Zoho Sheet

Pivot Tables lets you slice and dice the data in your spreadsheet and helps you gather meaningful insights from your data. Though Pivot Table was already available in Zoho Sheet, we have now completely revamped it, made it more powerful and have integrated it seamlessly into your spreadsheet experience. 

We provide you with an intuitive user interface where you can drag and drop fields into rows, columns, data and filter boxes to draw your Pivot Table.​ Here are the capabilities of our new Pivot Tables:
  1. Drag and drop up to 5 row fields and/or 5 column fields by which you need to group and aggregate your data. 

  2. Have 1 data field and aggregate it based on its Sum / Count / Maximum / Minimum / Product. We will be supporting more than 1 data field very soon.

  3. Date fields in Rows/Columns could be grouped by Year / Quarter / Month / Day / Day of Week / Quarter by Year / Month by Year.

  4. Add up to 5 filter fields to filter your Pivot Table.

  5. Sort and Filter the Pivot Table based on the row/column fields.

  6. Dress up your Pivot Tables with different colored styles readily available.

  7. A Pivot Table can be in a separate worksheet or it can reside in an existing worksheet. A single worksheet can contain multiple Pivot Tables.

  8. As the Pivot Table is more native to the spreadsheet now, they can be treated as normal cells in your spreadsheet. For example, you can refer to cells of a Pivot Table in a formula or Draw charts on top of a Pivot Table or Print the spreadsheet along with the Pivot Table. 

  9. Move your Pivot Table to a different location or change the source range when needed.

  10. When you import your spreadsheet, the Pivot Tables in it get imported as well. Export of Pivot Tables is also supported, except for the xlsx format where the data gets exported, but it won't be recognized as a Pivot Table.

  11. Use Refresh / Refresh All to refresh your Pivot Table when existing data is modified or new data is added to the source range.
You can invoke the Pivot Tables functionality by selecting your table range (or any cell in the range) and clicking on the 'Pivot Table' button available under the 'Data' tab.

Here are screenshots of our new Pivot Table:

Important Note: If you have the old ​Pivot Tables and Pivot Charts on your existing spreadsheets, ​we recommend you to recreate your Pivot Tables and Charts by October 15th 2015. The old Pivot Tables and Pivot Charts will not be rendered after that. For more information on this, refer this post.
Try the new Pivot Tables and share your feedback by replying to this post or by sending an email to

                            Zoho Desk Resources

                            • Desk Community Learning Series

                            • Digest

                            • Functions

                            • Meetups

                            • Kbase

                            • Resources

                            • Glossary

                            • Desk Marketplace

                            • MVP Corner

                            • Word of the Day

                                Zoho Marketing Automation

                                        • Sticky Posts

                                        • Format and analyze spreadsheet data with Zoho Sheet's Table

                                          While a spreadsheet helps you compile data for easy analysis, formatting helps make your data more comprehensible. We are happy to announce the release of Table, a crucial tool for improving data formatting in Zoho Sheet. More than a formatting tool,
                                        • Introducing Data Bars: Graphically represent changes in data within the cells

                                          Conditional formatting has helped millions of spreadsheet users analyze and highlight their data more efficiently. In addition to the classic rules, color scales, and icon sets available in Zoho Sheet, you can now apply Data Bars, a convenient method
                                        • Zia in Zoho Sheet now makes suggestions on conditional formats, picklists, and checkboxes

                                          Zia, Zoho's popular AI assistant, has been helping users succeed across Zoho applications since inception. In Zoho Sheet, Zia helps users efficiently build reports and analyze data with recommendations about data cleaning, charts, and pivot table. Also,
                                        • Revamped Print in Zoho Sheet—customized for paper

                                          The latest enhancements to Zoho Sheet's Print settings allows you to print a worksheet or a selected range, with customizations that make the data comprehensible, even on paper.   Customize header and footer Make your spreadsheets meaningful with a relevant header and footer. You can now choose to display the file name, sheet name, current page number, total pages, date, and time as the header and footer in your print view. Besides the predefined elements, you can also give a custom text for header/footer.
                                        • Check out the new Checkbox in Zoho Sheet

                                          Checkbox, the simple GUI widget that lets you choose between two mutually exclusive options i.e Yes or No, is now in Zoho Sheet. Having made it across the web, Checkbox is familiar but is still elusive to most spreadsheet software. Special developer ribbons, macros and all other complexities to add a checkbox to a spreadsheet? Not in Zoho Sheet. How to add Checkbox to Zoho Sheet? Adding a Checkbox in Zoho Sheet is simple. Select a cell/range and choose "Checkbox" in "Input Controls" under the Format

                                        Manage your brands on social media

                                                Zoho TeamInbox Resources

                                                  Zoho DataPrep Resources

                                                    Zoho CRM Plus Resources

                                                      Zoho Books Resources

                                                        Zoho Subscriptions Resources

                                                          Zoho Projects Resources

                                                            Zoho Sprints Resources

                                                              Qntrl Resources

                                                                Zoho Creator Resources

                                                                  Zoho WorkDrive Resources

                                                                    Zoho Campaigns Resources

                                                                      Zoho CRM Resources

                                                                      • CRM Community Learning Series

                                                                        CRM Community Learning Series

                                                                      • Tips


                                                                      • Functions


                                                                      • Meetups


                                                                      • Kbase


                                                                      • Resources


                                                                      • Digest


                                                                      • CRM Marketplace

                                                                        CRM Marketplace

                                                                      • MVP Corner

                                                                        MVP Corner

                                                                            Design. Discuss. Deliver.

                                                                            Create visually engaging stories with Zoho Show.

                                                                            Get Started Now