Odoo 16 Studio Book - Pivot Table

You may construct and customize pivot views for your custom models using the pivot view data analysis tool available in Odoo Studio. The pivot view in Studio is an effective tool for data analysis and aids in the creation of personalized data views that satisfy your unique business needs. With the help of this tool, you can design unique dashboards and reports that offer insightful analyses of your company's data.

  • Based on your unique models, create custom pivot views.
  • To generate a multidimensional view of your data, group data by one or more fields.
  • Filter the data using specific criteria to narrow the data and focus on certain data points.
  • To acquire an overview of the data collection, aggregate it using various functions such as count, sum, average, and more.
  • Customize the pivot view's appearance and layout, including column and row headings, summary fields, and more.
  • Create unique charts and graphs depending on the data set to display the data in a more relevant way.

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


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


For parameter-based column grouping

In the Studio Pivot Table, column grouping refers to the process of grouping columns together based on specified criteria.


For parameter-based row grouping

Rows grouping in the Studio Pivot Table refers to the process of grouping rows together based on specified criteria. In other words, it enables you to organize the rows in your pivot table by establishing a hierarchy that puts relevant rows together.


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


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

Added measures as “ amount to invoice”.


In conclusion, the Pivot Table feature in the Studio module of Odoo offers a user-friendly and powerful solution for data analysis, summarization, visualization, and report generation, enabling 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