Skip to Content
Menu
This question has been flagged
1 Odpoveď
4570 Zobrazenia

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
Zrušiť
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
Zrušiť
Autor

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 Zobrazenia Aktivita
2
okt 25
2728
1
sep 25
2739
3
júl 25
4122
1
máj 25
2210
4
máj 25
3572