Přejít na obsah
Menu
You need to be registered to interact with the community.
This question has been flagged
6523 Zobrazení

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?

Avatar
Zrušit
Related Posts Odpovědi Zobrazení Aktivita
1
bře 20
4089
1
srp 16
4706
3
úno 25
4632
1
čvc 24
29
1
čvn 24
1545