Question on Grouping

[Jaddy Balagtas]

I have a data set with region, Country and Cities. I want to have them in Groups in a Pivot table.

[TABLE="width: 579"]
<colgroup><col><col><col span="2"><col><col><col></colgroup><tbody>[TR]
[TD]Region[/TD]
[TD]Country[/TD]
[TD]Location[/TD]
[TD]Daily Sales[/TD]
[TD]Weekly Sales[/TD]
[TD]Month To Date[/TD]
[TD]Year to Date[/TD]
[/TR]
[TR]
[TD]Asia[/TD]
[TD]China[/TD]
[TD]Hong Kong[/TD]
[TD="align: right"]100[/TD]
[TD="align: right"]500[/TD]
[TD="align: right"]4000[/TD]
[TD="align: right"]40000[/TD]
[/TR]
[TR]
[TD]Macau[/TD]
[TD="align: right"]200[/TD]
[TD="align: right"]500[/TD]
[TD="align: right"]4000[/TD]
[TD="align: right"]40000[/TD]
[/TR]
[TR]
[TD]Beijing[/TD]
[TD="align: right"]150[/TD]
[TD="align: right"]400[/TD]
[TD="align: right"]4000[/TD]
[TD="align: right"]40000[/TD]
[/TR]
[TR]
[TD]Japan[/TD]
[TD]Nagoya[/TD]
[TD="align: right"]200[/TD]
[TD="align: right"]300[/TD]
[TD="align: right"]4000[/TD]
[TD="align: right"]40000[/TD]
[/TR]
[TR]
[TD]Okazaki[/TD]
[TD="align: right"]300[/TD]
[TD="align: right"]500[/TD]
[TD="align: right"]4000[/TD]
[TD="align: right"]40000[/TD]
[/TR]
[TR]
[TD]Singapore[/TD]
[TD]Kallang[/TD]
[TD="align: right"]100[/TD]
[TD="align: right"]300[/TD]
[TD="align: right"]4000[/TD]
[TD="align: right"]40000[/TD]
[/TR]
[TR]
[TD]Jurong[/TD]
[TD="align: right"]300[/TD]
[TD="align: right"]500[/TD]
[TD="align: right"]4000[/TD]
[TD="align: right"]40000[/TD]
[/TR]
[TR]
[TD]Middle East[/TD]
[TD]Dubai[/TD]
[TD]Dubai[/TD]
[TD="align: right"]400[/TD]
[TD="align: right"]600[/TD]
[TD="align: right"]4000[/TD]
[TD="align: right"]40000[/TD]
[/TR]
[TR]
[TD]Abu Dhabi[/TD]
[TD="align: right"]100[/TD]
[TD="align: right"]300[/TD]
[TD="align: right"]4000[/TD]
[TD="align: right"]40000[/TD]
[/TR]
[TR]
[TD]Saudi Arabia[/TD]
[TD]Jeddah[/TD]
[TD="align: right"]150[/TD]
[TD="align: right"]400[/TD]
[TD="align: right"]4000[/TD]
[TD="align: right"]40000[/TD]
[/TR]
[TR]
[TD]Riyadh[/TD]
[TD="align: right"]500[/TD]
[TD="align: right"]600[/TD]
[TD="align: right"]4000[/TD]
[TD="align: right"]40000
[/TD]
[/TR]
</tbody>[/TABLE]


If I add them in the rows in the pivot it will look like this
[TABLE="width: 94"]
<colgroup><col></colgroup><tbody>[TR]
[TD]Asia[/TD]
[/TR]
[TR]
[TD]China[/TD]
[/TR]
[TR]
[TD]Hongkong[/TD]
[/TR]
[TR]
[TD]Macau[/TD]
[/TR]
[TR]
[TD]Beijing[/TD]
[/TR]
[TR]
[TD]Japan[/TD]
[/TR]
[TR]
[TD]Nagoya[/TD]
[/TR]
[TR]
[TD]Okazaki[/TD]
[/TR]
[TR]
[TD]Singapore[/TD]
[/TR]
[TR]
[TD]Kallang[/TD]
[/TR]
[TR]
[TD]Jurong[/TD]
[/TR]
[TR]
[TD]Middle East[/TD]
[/TR]
[TR]
[TD]Dubai[/TD]
[/TR]
[TR]
[TD]Dubai[/TD]
[/TR]
[TR]
[TD]Abu Dhabi[/TD]
[/TR]
[TR]
[TD]Saudi Arabia[/TD]
[/TR]
[TR]
[TD]Jeddah[/TD]
[/TR]
[TR]
[TD]Riyadh

[/TD]
[/TR]
</tbody>[/TABLE]


I need the Region,Country and Cities to be in a different column.

 

[Jaddy Balagtas]

Also is it possible to have the Daily Sales, Weekly Sales, Monthly Sales and Yearly Sales in each column. Using only 1 data set?