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

Hello all!

I'm on odoo 8.

Do you have a trick to remove the total column at the right of the pivot table (see image below).

Do I have to make some javascript for this? I hope not...


XML

<record id="view_account_invoice_report_period_graph_vtm2" model="ir.ui.view">
 <field name="name">account.invoice.report.period.graph.vtm2</field>
 <field name="model">account.invoice.report.vtm2</field>
 <field name="arch" type="xml">
     <graph string="Invoices Analysis" type="pivot">
         <field name="fiscal_position" type="row"/>
         <field name="period_id" type="col"/>
         <field name="price_total" type="measure"/>
     </graph>
 </field>
 </record>


Image


Avatar
Opusti
Best Answer

Just un mark it from Measures.

Avatar
Opusti
Avtor

The measure is for each column. Not just the total column at the right. If I uncheck it, there is no more columns.

Hai Pascal Tremblay,

You must have to select any of the measures from the list.Otherwise its shows nothing.

That means, Uncheck the Total column first.then select another measure that you want.

Then click the (-)Total in the top.

Avtor

Thanks for this answer. I would like to display the pivot table directly without the total column. Without click. I thought that we could make it in XML... It seems that it is not possible.

Ohh...is that your need??

you can done this by the help of xml.

use this code.

<?xml version="1.0" encoding="UTF-8" ?>

<openerp>

<data>

<record id="measure_test_sales" model="ir.ui.view">

<field name="name">measure_test_sales.view</field>

<field name="model">sale.report</field>

<field name="inherit_id" ref="sale.view_order_product_pivot"/>

<field name="arch" type="xml">

<xpath expr="//field[@name='price_subtotal']" position="replace">

<field name="price_subtotal" />

</xpath>

</field>

</record>

</data>

</openerp>

Best Answer

find data relation in your python file and set store value false. 


For example:

pivot_percentage = fields.Float("Percentage", compute="_pivot_percentage_compute", store=False)

Avatar
Opusti
Related Posts Odgovori Prikazi Aktivnost
1
dec. 22
3595
1
jul. 21
3948
2
feb. 17
6166
1
apr. 24
3599
2
sep. 24
1915