Skip to Content
Menu
This question has been flagged
1 Reply
3146 Views

I would like, in pivot view, to have a column to show "count" values as a percentage o total count. Any idea in how to got it? Thanks

Avatar
Discard
Best Answer

Adding a field to the Pivot view is not easy and probably not advised as the pivot view is changeable by many dimensions.

However, there are two easy way to do this:

- Export the Pivot as an .xlsx file and do the calculations manually in Excel/Google sheets.

        -    The issue here is the data will not update as it is updated in the system, which may be an issue for you

If you want to be able to view real-time data then you can link the pivot view to an Odoo spreadsheet. Add the column with whatever calculations you want and the data will update as there are changes in the system. 

More info here: https://www.youtube.com/watch?v=tPNqVfUB4zw

Avatar
Discard
Author

Thanks Lucas. This feature is really fantastic. Unfortunately only available for enterprise version

@Javier

Maybe it's time to upgrade then ;)

In the future, it is best to specify the version of Odoo you are using to get the most relevant answers. I hope you find a solution that works for you here

Related Posts Replies Views Activity
2
Dec 24
3136
1
Dec 24
359
4
Nov 24
1368
1
Sep 24
1138
1
Sep 24
1205