Skip to Content
Menu
Musisz się zarejestrować, aby móc wchodzić w interakcje z tą społecznością.
To pytanie dostało ostrzeżenie
6 Odpowiedzi
14670 Widoki

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


Awatar
Odrzuć
Najlepsza odpowiedź

Just un mark it from Measures.

Awatar
Odrzuć
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>

Najlepsza odpowiedź

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)

Awatar
Odrzuć
Powiązane posty Odpowiedzi Widoki Czynność
1
gru 22
3569
1
lip 21
3925
2
lut 17
6113
1
kwi 24
3584
2
wrz 24
1844