Studio Book V17: Pivot Table

Pivot Table

Using the pivot view data analysis tool in Odoo Studio, you can create and customize pivot views for your custom models.

The pivot view in Studio is an excellent data analysis tool that supports the construction of personalized data views that meet your specific business requirements. You can use this tool to create unique dashboards and reports that provide analytical assessments of your company's data.

  • Create bespoke pivot views based on your specific models.
  • Group data by one or more fields to generate a multidimensional view of your data.
  • Filter the data using specific criteria to narrow it down and concentrate on specific data points.
  • Aggregate the data collection using various functions such as count, sum, average, and more to gain an overview.
  • Customize the appearance and layout of the pivot view, including column and row headings, summary fields, and more.
  • Create unique charts and graphs based on the data set to display the data more effectively.

The pivot view is located under the reporting views in the studio.


By enabling this, the user can access the records from the table.


For parameter-based column grouping

Column grouping in the Studio Pivot Table refers to the process of grouping columns together based on specified criteria.


For parameter-based row grouping

The process of grouping rows in the Studio Pivot Table is referred to as row grouping. To put it another way, it allows you to organize the rows in your pivot table by creating a hierarchy that groups relevant rows together.


Row grouping - The second level lets you enhance row grouping even further by adding a further degree of grouping.


Measures in the Odoo 17 Studio Pivot Table refer to the quantitative values being analyzed in the pivot table.

Measures such as "amount to invoice" have been added.


Finally, the Odoo Studio module's Pivot Table feature provides a user-friendly and powerful solution for data analysis, summarization, visualization, and report generation, allowing users to gain valuable insights and make informed decisions based on their data.



Cybrosys Technologies Pvt. Ltd.
Neospace, Kinfra Techno Park
Kakkancherry, Calicut
Kerala, India - 673635



Cybrosys Technologies Pvt. Ltd.
1st Floor, Thapasya Building,
Infopark, Kakkanad,
Kochi, India - 682030.



Cybrosys Techno Solutions
The Estate, 8th Floor,
Dickenson Road,
Bangalore, India - 560042

Send Us A Message