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 support@zohosheet.com.




      • Sticky Posts

      • Slicers are now available in Zoho Sheet—filter your data interactively

        At Zoho Sheet, we diligently track user requests and feedback. In line with this, based on extensive user requests, we've integrated Slicers to pivot tables and are delighted to announce its release. Slicers are interactive visual filters that have add,

      • 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

      • 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,