Hi,

How can I get a pivot view on account.move.line where I can filter or group by analytic tags?

Relationships: account.move.line many2one account.analytic.account many2many account.analytic.tag

Thanks for any help! Below is a simple view, and I want to replace the column field with account.analytic tag:

<openerp>

<data>

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

<field name="name">account.move.line.pivot</field>

<field name="model">account.move.line</field>

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

<pivot string="Accounting Analysis">

<field name="account_id" type="row"/>

<field name="analytic_account_id" type="col"/>

<field name="balance" type="measure"/>

</pivot>

</field>

</record>

<record model="ir.actions.act_window" id="action_account_move_line_pivot">

<field name="name">action_account_move_line_pivot</field>

<field name="res_model">account.move.line</field>

<field name="view_mode">pivot</field>

<field name="view_id" ref="view_account_move_line_pivot"/>

</record>

<menuitem id="menu_account_move_line_pivot" parent="account.account_reports_business_intelligence_menu" name="Journal Items" sequence="10" action="action_account_move_line_pivot"/>

</data>

</openerp>