Přejít na obsah
Menu
You need to be registered to interact with the community.
This question has been flagged
6652 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
4183
1
srp 16
4793
3
úno 25
4795
1
čvc 24
29
1
čvn 24
1721