Views in Odoo - Advanced Views - Pivot View in Odoo 17

In Odoo, the pivot view is a graphical representation of data that allows users to analyze and summarize large datasets quickly. It's a powerful tool for generating insights from your business data.
The pivot view in Odoo is a valuable tool for analyzing and summarizing large datasets, helping you gain insights into your business operations.

1. Advanced Views - Pivot View in Odoo 17 Enterprise

2. Introduction Enterpr ise In Odoo, the pivot view is a graphical representation of data that allows users to analyze and summarize large datasets quickly. It's a powerful tool for generating insights from your business data. The pivot view in Odoo is a valuable tool for analyzing and summarizing large datasets, helping you gain insights into your business operations.

3. Enterprise We’ve created a custom module ‘travel_management’ with basic fields, actions, menus along with form and tree views. Here's how you can use the pivot view in Odoo. First, add pivot also in the ‘view_mode’ for the action for the model. <record id="action_travel" model="ir.actions.act_window"> <field name="name">Travel Card</field> <field name="res_model">travel.booking</field> <field name="view_mode">tree,form,pivot</field> </record>

4. Enterprise The view is defined using the <pivot> tag inside the ‘arch’ field. We can define the fields and their type that needed to be shown on the pivot. The fields we want to use as rows, columns and measures can be set inside the tag. <record id="travel_booking_pivot_view" model="ir.ui.view"> <field name="name">travel.booking.pivot.view</field> <field name="model">travel.booking</field> <field name="arch" type="xml"> <pivot string="Booking Analysis"> <field name="partner_name" type="row"/> <field name="partner_mobile" type="col"/> </pivot> </field> </record> Next, give the code for the pivot view as

5. Enterprise Now, go to the module’s menu. Take the concerned model’s view. We can see the new icon of ‘pivot’ view on top.

6. Enterprise The fields can be designed in rows, columns or as measures. Clicking on the icon, we get the Pivot view, that we’ve designed from backend using code.

7. For More Info. Check our company website for related blogs and Odoo book. Check our YouTube channel for functional and technical videos in Odoo. Enterprise www.cybrosys.com