Hello,
Is there a way to make a pivot table (that is NOT aggreagated) editable directly from the pivot view?
For example let's say I have my model as the following:
| product_id | date | qty |
| p1 | 01/11/2021 | 10 |
| p1 | 01/12/2021 | 20 |
| p2 | 01/11/2021 | 30 |
and I want to use a pivot view to show the table by date columns and qty as values (NO aggregation will be used, meaning NO sum/avg/count funtions are needed) while making the pivot table editable so the user can edit the values directly, see bellow example for reference:
| product_id | 01/11/2021 | 01/12/2021 |
| p1 | 10 | 20 |
| p2 | 30 | 0 |
Please let me know if you have any ideas how to do so. Thanks!
Hi,
There is no direct editing methods in pivot view, You can only customise the fields and measures in pivot view. There is an option for import to spreadsheet in odoo, After importing to xlsx you can easily edit the view. That is the only way for editing pivot view data.