- Downloading and Installing PowerPivot
- Getting your Data into PowerPivot
- Linking an Excel Table to PowerPivot
- Importing Data into PowerPivot
- Adding DAX Calculations to the Grid
- Creating Pivot Tables from PowerPivot
- Defining a Relationship Between Worksheets
- Using Automatic Relationship Detection
- Using Explicit Relationships
- Using the RELATED Function in the PowerPivot Grid
- Adding Slicers to Drive All Pivot Elements
- Adding DAX Calculations to the PivotTable
- Entering a Measure
- Using the X Functions
- Using CountRows and Distinct
- PowerPivot Is a Home Run
Using Explicit Relationships
If you don't want to let PowerPivot detect the relationships, you can explicitly define the relationship. Follow these steps:
- On the PowerPivot ribbon tab in Excel, choose PowerPivot window.
- Click in the StoreID field on one worksheet.
- Select the Design ribbon tab in the PowerPivot window.
- Click the Create Relationships icon.
- In the Create Relationship dialog, choose the similar field in the other worksheet. Click OK to define the relationship.
You might wish to use the Create Relationship dialog instead of letting the pivot table auto-detect the relationships when you need to reference the field from another worksheet in a grid calculation.