Would you have a trick to remove the total column on pivot table?

<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

Avinash Nk

Just un mark it from Measures.

Pascal Tremblay

Author

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

Avinash Nk

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.

Pascal Tremblay

Author

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.

Avinash Nk

Ohh...is that your need??

you can done this by the help of xml.

use this code.

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

<data>

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

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

</xpath>

</field>

</record>

</data>