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
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- Accounting
- Inventory
- PoS
- Project management
- MRP
This question has been flagged
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
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
Enjoying the discussion? Don't just read, join in!
Create an account today to enjoy exclusive features and engage with our awesome community!
Sign upRelated Posts | Replies | Views | Activity | |
---|---|---|---|---|
|
2
Dec 24
|
3136 | ||
|
1
Dec 24
|
359 | ||
|
4
Nov 24
|
1368 | ||
|
1
Sep 24
|
1138 | ||
|
1
Sep 24
|
1205 |