Database Reference
In-Depth Information
Figure 10-6.
Using a user hierarchy in Excel
In our example, we grouped authors by states by dragging and dropping the AuthorState attribute into the
Hierarchies pane and then dragging and dropping the child-level attribute, Author, beneath it (Figure
10-7
). Once
this is set, reporting software like Excel can easily browse the authors grouped by state.
