I have a geographical hiearchy of zone, region, district, territory in a report. When the output is exported to Excel, the first few columns are zone, region, district territory followed by the data.
Country
Total
Country
Zone 1
Total
Country
Zone 1
Region 1
Country
Zone 1
Region 2
Country
Zone 1
Region 3
Country
Zone 1
Region 4
Country
Zone 1
Region 5
Country
Zone 1
Region 6
Country
Zone 1
Region 7
Country
Zone 1
Region 8
Is there any way to format the data in this fashion:
Country Total
Zone 1 Total
Region 1
Region 2
Region 3
Region 4
Region 5
Also can we show the country and Zone rows in a different colour.
