Archives
Contributors
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#L237
Regards.
by Pedro M. Baeza - 10:11 - 21 Aug 2019
Reference
-
Smart aggregate cells in pivot tables including calculations
Hi AllIt 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 developmentKind regardsJonathan WilsonChief Sales and Innovation ExecutiveWilldooIT Pty LtdRecent Linkedin articles: How to Assess if you've Outgrown Your Business Accounting or ERP SystemFirst Australian Odoo GOLD partner2017, 2015 & 2013 Odoo Best Partner Asia/PacificCreators of Odoo-Pentaho integration project"Making growth through technology easy"P: +61 3 9135 1900M: +61 4 000 17 44410/435 Williamstown RoadPort Melbourne VIC 3207DISCLAIMER | This electronic message together with any attachments is confidential. If you are not the recipient, do not copy, disclose, or use the contents in any way. Please also advise us by e-mail that you have received this message in error and then please destroy this email and any of its attachments. WilldooIT Pty. Ltd. is not responsible for any changes made to this message and/or any attachments after sending by Willdoo IT Pty. Ltd. WilldooIT Pty. Ltd. use virus scanning software but exclude all liability for virus or anything similar in this email or attachment.
by Jonathan Wilson - 09:55 - 21 Aug 2019-
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
-
