From the course: SharePoint Advanced: Working with PowerPivot

Unlock this course with a free trial

Join today to access over 25,600 courses taught by industry experts.

Establish hierarchies

Establish hierarchies

From the course: SharePoint Advanced: Working with PowerPivot

Start my 1-month free trial Buy for my team

Establish hierarchies

“

- [Instructor] Another nice feature that we have available to us is the ability to set up hierarchies within the tables that we're using for our Power Pivot Pivot Tables. This allows extra drill down functionality and enables some other pretty cool stuff. So, let's set up a hierarchy in our Regions table. We'll start by going back into Power Pivot and Power Pivot, and Manage, and we'll go back to the Diagram View. If we go over into the Region and we float here, you can see there's a little prompt there for create a hierarchy. We'll click that and this will give us the opportunity to name this. Let's do something really obvious like RegionHierarchy. Now, we've created that. Now, let's take the region and drag it, and you gotta put it right on top, and see it turns color, there. So, that's the first thing under the hierarchy. Now we'll put State under Region. So, State will feed up to Region. That'll be the order of the hierarchy. Fairly simple. Now, go ahead and get out of there. Go…

Contents