PowerPivot – Creating Hierarchies in PowerPivot for Excel 2010

In this post, we will see how to create Hierarchies in a Table in PowerPivot for Excel. We will look at the following two scenarios for building Hierarchies:

  • Creating Hierarchies using Columns from the Same Table
  • Creating Hierarchies using Columns from Different Tables

To start working with the steps in this post, setup your Excel/PowerPivot workbook and add the following items to your workbook:

To read the full article, go to this link: Creating Hierarchies in PowerPivot for Excel.

Advertisements

About Dattatrey Sindol (Datta)

Datta is a Microsoft BI Enthusiast, passionate developer, and a blogger. View Full Profile

Posted on April 4, 2013, in MS Excel, MS Office, Power Pivot and tagged , , , , , . Bookmark the permalink. Leave a comment.

What are your thoughts?

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: