22-Pivot View in Odoo

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: https://github.com/CybroOdoo/openacademy The pivot view is used to visualize aggregations as a pivot table. Its root element is 〈pivot〉 which can take the following attributes: disable_linking Set to True to remove table cell’s links to list view. display_quantity Set to true to display the Quantity column by default. default_order 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) string the name that will be used to display the field in the pivot view, overrides the default python String attribute of the field. type 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. col creates column-wise groups measure field to aggregate within a group interval 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). invisible 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: https://www.cybrosys.com/ Connect with us: Facebook: http://ow.ly/Ty0Q30lc5TU twitter: http://ow.ly/s5cV30lc5Vc LinkedIn: http://ow.ly/GJfg30lc5WT Pinterest: http://bit.ly/2I2b5N0 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.