Skip to Content
Menu
You need to be registered to interact with the community.
This question has been flagged
1 Odgovori
4566 Prikazi

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
Opusti
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
Opusti
Avtor

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 Odgovori Prikazi Aktivnost
2
okt. 25
2728
1
sep. 25
2739
3
jul. 25
4122
1
maj 25
2210
4
maj 25
3572