Hierarchies:

Hierarchies:
We use Hierarchies to organise the data
from Top Level information to Bottom level Information.
Top Level Information hold the Summary data, Bottom Level holds detail level data.
Sum up the bottom level data to get next level data.

Creating Hierarchies:Geographical
1) Before start creating Hierarchies, define no. of level &
Which level data holds in which column
2) The following are sequence of levels
Region -> State -> City
3) Right click on Region, click on "Create Hierarchy".
4) Define Name of the Hierarchy as "Location", then Add  the Region to this Hierarchy.
5) Then right click on "State" then click on "add to Hierarchy" then click on "Location".
6) Add rest of the levels to hierarchy.