Odoo Help

Welcome!

This community 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.

0

Pivot table with multiple fields per group

By
Mathieu Laflamme
on 8/30/16, 3:48 PM 319 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

Country-->State-->City

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 community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

1 follower(s)

Stats

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