Odoo Help


Pivot table with multiple fields per group

Mathieu Laflamme
on 8/30/16, 3:48 PM 483 views

It would be so useful to be able to create a pivot table and have more than a field in a group. Let say you want to group by city only, but you want to show the country and state as well in a different column, but without having a breakdown like


I would just like something like:

| ------------------------------------------------|--------------------|  

|                                                            |  +  Total          |

| ------------------------------------------------|--------------------|  

|                                                            |    Quantity      |


| Montreal       | Quebec | Canada |        15             |

| Sherbrooke  | Quebec | Canada |         12             |

| Roberval       | Quebec | Canada |          5              |   

| Calgary         | Alberta  | Canada |         20             |   


I don't want to merge all my fields in a single column because I want the export feature to export the values in separate fields.

Is there a way to do that?

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

1 follower(s)


Asked: 8/30/16, 3:48 PM
Seen: 483 times
Last updated: 8/30/16, 4:27 PM