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?