Skip ke Konten
Menu
Pertanyaan ini telah diberikan tanda
6 Replies
14628 Tampilan

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
Buang
Jawaban Terbai

Just un mark it from Measures.

Avatar
Buang
Penulis

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.

Penulis

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>

Jawaban Terbai

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
Buang
Post Terkait Replies Tampilan Aktivitas
1
Des 22
3532
1
Jul 21
3893
2
Feb 17
6092
1
Apr 24
3556
2
Sep 24
1805