We have the sales of different Stores of a chain store in different cities

Data may be sorted. For each city, the stores are sorted based on Grand Total. Different Cities are also sorted based on their Grand Total.

A higher level of hierarchy may also be added manulay for example to combine a couple of cities to a division.