Archives
Contributors
Smart aggregate cells in pivot tables including calculations
| Hi All It would be really excellent if the pivot table views allowed for calculations like margins which correctly worked when aggregated (grouped), without resorting to custom reports, exports to excel or a professional BI tool. Has anyone cracked this requirement yet? Or are there any project in development Kind regards  Jonathan Wilson Chief Sales and Innovation Executive WilldooIT Pty Ltd Recent Linkedin articles: How to Assess if you've Outgrown Your Business Accounting or ERP System First Australian Odoo GOLD partner 2017, 2015 & 2013 Odoo Best Partner Asia/Pacific Creators of Odoo-Pentaho integration project
| ||||||
by Jonathan Wilson - 09:55 - 21 Aug 2019
Follow-Ups
-
Re: Smart aggregate cells in pivot tables including calculations
You can trick this with custom development overriding `read_group` method, but there's no tool for doing via UI AFAIK.Example of column that is computed as difference between 2 other aggregated columns:- Definition of the field (regular one): https://github.com/OCA/hr/blob/28e104e5abb5a4e6e1351e8c62339bff9c40f49d/hr_attendance_report_theoretical_time/reports/hr_attendance_theoretical_time_report.py#L34- Value altered in read_group method: https://github.com/OCA/hr/blob/28e104e5abb5a4e6e1351e8c62339bff9c40f49d/hr_attendance_report_theoretical_time/reports/hr_attendance_theoretical_time_report.py#L237Regards.
by Pedro M. Baeza - 10:11 - 21 Aug 2019