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?
