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.

Region	Country	Location	Daily Sales	Weekly Sales	Month To Date	Year to Date
Asia	China	Hong Kong	100	500	4000	40000
Macau	200	500	4000	40000
Beijing	150	400	4000	40000
Japan	Nagoya	200	300	4000	40000
Okazaki	300	500	4000	40000
Singapore	Kallang	100	300	4000	40000
Jurong	300	500	4000	40000
Middle East	Dubai	Dubai	400	600	4000	40000
Abu Dhabi	100	300	4000	40000
Saudi Arabia	Jeddah	150	400	4000	40000
Riyadh	500	600	4000	40000

<colgroup><col><col><col span="2"><col><col><col></colgroup><tbody>
</tbody>

If I add them in the rows in the pivot it will look like this

Asia

China

Hongkong

Macau

Beijing

Japan

Nagoya

Okazaki

Singapore

Kallang

Jurong

Middle East

Dubai

Dubai

Abu Dhabi

Saudi Arabia

Jeddah

Riyadh

<colgroup><col></colgroup><tbody>
</tbody>

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?