PowerPivot - Creating Hierarchies
Hierarchies are one of the long awaited features that will now be available in the latest version of PowerPivot. Hierarchies are useful because it allows a single click for a user to bring in all the fields that exist in a natural table hierarchy. Normally the user would have to drag in all fields individually so this can be a time saver especially if it is an 8 level hierarchy.
Read more...