How can I edit Pivot table row totals?

Question

Odoo 16 - I'd like to be able to edit the totals for rows on Pivot tables.  Perhaps add a second total that's customized.  How can I do this?
Example, you can see in the screenshot the total "Untaxed Total" to the right?
I'd like to add another column that was that total minus the total in the Deliveries column.  I can't find the code in Odoo to inherit that produces the totals though.

Screenshot:
https://pasteboard.co/S8cQOFPIkauo.png [1]

[1] https://pasteboard%5C.co/S8cQOFPIkauo%5C.png

Cybrosys Techno Solutions Pvt.Ltd · Answer

Hi,
Pivot row totals in Odoo 16 are computed automatically in the JS pivot model and are not editable database fields.
You cannot directly inherit or modify the row total column from Python because totals are generated dynamically from read_group() results.
To add a custom total (e.g., Untaxed Total − Deliveries), create a new computed (preferably stored) field in the model.
Add that computed field as a measure in the pivot view so it aggregates and shows its own row totals automatically.
Altern

Aiheeseen liittyviä artikkeleita	Vastaukset	Näkymät
How to add UOM (unit of measure) field in Pivot view pivot odoo16features	0 helmik. 23	2817
Pivot by Day / Week / Month / Quarter / Year, xml file path? pivot	1 toukok. 26	3691
DeprecationWarning: The longpolling-port is a deprecated alias to the gevent-port option, please use the latter Ratkaistu odoo16features	5 syysk. 25	30127
How to Add wizard under print button inside the form view. odoo16features	3 elok. 25	6529
How to add @api.onchange in _get_view() method odoo 16 odoo16features	1 toukok. 25	5985

Tämä kysymys on merkitty

Nautitko keskustelusta? Älä vain lue, vaan osallistu!