Skip to Content
  2. Mailing Lists
  3. Contributors
  4. Re: Smart aggregate cells in pivot tables including calculations

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:


Regards.
by Pedro M. Baeza - 10:11 - 21 Aug 2019

Reference

  • 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


    First Australian Odoo GOLD partner
    2017, 2015 & 2013 Odoo Best Partner Asia/Pacific
    Creators of  Odoo-Pentaho integration project
    "Making growth through technology easy"

    P: +61 3 9135 1900
    M: +61  4 000 17 444
    10/435 Williamstown Road
    Port Melbourne VIC 3207
    DISCLAIMER | 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