Skip to Content
Menu
This question has been flagged
6 Replies
14690 Zobrazenia

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

Just un mark it from Measures.

Avatar
Zrušiť
Autor

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.

Autor

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
Zrušiť
Related Posts Replies Zobrazenia Aktivita
1
dec 22
3590
1
júl 21
3946
2
feb 17
6144
1
apr 24
3599
2
sep 24
1908