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:
- Import “DimDate”, “DimEmployee”, “DimReseller”, “DimGeography”, “Sales Territory Query” (“DimSalesTerritory” table imported using a query) and “FactResellerSales” tables from AdventureWorksDW database into PowerPivot (Refer to Importing SQL Server Data from Multiple Data Sources into PowerPivot for Excel)
- Add a New Column “SortedMonth” (Equal to “Month”) and set the column sorting to “MonthNumber” in “DimDate” (Refer to “Applying Custom Sorting on Column Data” in this tip: Working with Columns and Properties in PowerPivot for Excel)
To read the full article, go to this link: Creating Hierarchies in PowerPivot for Excel.
- PowerPivot – Working with Column Properties in PowerPivot for Excel 2010
- PowerPivot – Combine Data from Multiple Relational Tables into One Table in PowerPivot for Excel
Posted on April 4, 2013, in MS Excel, MS Office, Power Pivot and tagged Business Intelligence, Databases, Excel, Microsoft Excel, Microsoft SQL Server, Power Pivot. Bookmark the permalink. Leave a comment.