This video explains about the pivot view in odoo. In Pivot view, data can be represented as tables, a dynamic analysis matrix.

Pivot view repeatedly generates table dynamically, while changing the field or row or column. The user can select the row and column field to represent the table. Each time when a user changes the fields, it calls corresponding SQL queries and produces tables accordingly. So Pivot tables are called as dynamic analysis matrix.

Get the module from our repository:

The pivot view is used to visualize aggregations as a pivot table. Its root element is 〈pivot〉 which can take the following attributes:

Set to True to remove table cell’s links to list view.

Set to true to display the Quantity column by default.

The name of the measure and the order (asc or desc) to use as default order in the view.

name (required)
the name of a field to use in the view. If used for grouping (rather than aggregating)

the name that will be used to display the field in the pivot view, overrides the default python String attribute of the field.

indicates whether the field should be used as a grouping criteria or as an aggregated value within a group. Possible values are:

row (default)
groups by the specified field, each group gets its own row.

creates column-wise groups

field to aggregate within a group

on date and datetime fields, groups by the specified interval (day, week, month, quarter or year) instead of grouping on the specific datetime (fixed second resolution) or date (fixed day resolution).

if true, the field will not appear either in the active measures nor in the selectable measures (useful for fields that do not make sense aggregated, such as fields in different units, e.g. € and $).

#odoodevelopment #odootutorials #odoo13
For More Videos Subscribe to our YouTube channel.

Visit our company website:

Connect with us:

About Us
Cybrosys is enriched with technical experts and research scholars producing high-end quality software tools. Our sophisticated infrastructure and lab facilities constantly bring in new technological innovations and attributions. Partnership with ODOO, MICROSOFT, IBM, Intel, HP, NASSCOM proves our strength and excellence.

We are Odoo Gold Partners standing par excellence in Odoo Implementation, Customization, and allied services. We do Source code sale, Custom software development, and Employee outsourcing. The latest research and developments in Cybrosys are being conducted in Blockchain. Our robust quality product and services are widely used by clients residing across in India, USA, UK, Middle East & Europe.
4238 Total Views
0 Members Views
4238 Public Views
Поделиться в социальных сетях
Поделиться ссылкой
Use permanent link to share in social media
Share by mail

Пожалуйста Логин to share this video by email.

Встроить в свой сайт