Introduction to Pivot Table
Pivot Table allows you to dynamically rearrange, group and summarize data for easy analysis of large sets of data. You can transform data in a table(s) into interactive and meaningful summaries easily by using intuitive drag and drop interface provided by Zoho Analytics. You can also filter, sort and customize the appearance and content of your Pivot Table the way you want it, by using wide range of options provided by Zoho Analytics. For users who view/access the pivot tables, Zoho Analytics offers a range of interactivity options like View underlying data, User Filters, Sorting, Export etc.,
The following screenshot displays the basic layout of a Pivot Table in Design Mode .
- Columns from the source table that you assign to a row orientation in a Pivot Table.
- Values of the column from the source table that you assign to a column orientation in a Pivot Table.
- Column from the source table that contains values to be summarized.
- Column/Rows in the Pivot Table that contains grand summary information.
Watch the below video to get a quick overview on creating Pivot Tables.
In this chapter we will discuss the following:
Access your files securely from anywhere
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 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 Workerly Home
- Forums
- Connect With Us:
- Zoho Recruit Home
- Forums
- Connect With Us:
All-in-one knowledge management and training platform for your employees and customers.
Create. Review. Publish.
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.
Zoho Sheet Resources
Zoho Forms Resources
Zoho Sign Resources
Sign, Paperless!
Zoho TeamInbox Resources
Design. Discuss. Deliver.
Related Articles
Customizing a Pivot Table
When designing a Pivot Table, Zoho Analytics offers a wide range of options to customize it and improve the overall appearance in different ways. In this section, we will discuss about various options provided by Zoho Analytics to customize the Pivot ...Creating a New Pivot Table
A Pivot Table allows you to dynamically summarize large amounts of data for easy analysis and visualization. You can transform data in a table(s) into meaningful summaries easily by using the intuitive drag and drop interface provided by Zoho ...Working with Pivot Tables
Zoho Analytics offers a wide range of interactive options on a Pivot Table when accessed by an end-user. The options include Expand/Collapse, Viewing Underlying data, sorting, exporting, sharing and publishing a Pivot Table. In this section, we will ...Visuals in Pivot
Visuals in Pivot Pivot table offers you the following visualization options to enhance data representation. Sparkline Charts Data Bars Sparkline Charts Sparklines are compact, multi-point visual charts that show the trends and variations in the data, ...Introduction to Workspace
Workspaces are where you create and manage all your views for reporting and analysis. This allows you to logically group your data sets (stored in entities called Tables) and create insightful reports and Dashboard over your data. Further, it ...