I have a data set with region, Country and Cities. I want to have them in Groups in a Pivot table.
<colgroup><col><col><col span="2"><col><col><col></colgroup><tbody>
Region
Country
Location
Daily Sales
Weekly Sales
Month To Date
Year to Date
Asia
China
Hong Kong
100
500
4000
40000
Macau...