Home > Articles > Home & Office Computing > Microsoft Applications

  • Print
  • + Share This
From the author of Using Explicit Relationships

Using Explicit Relationships

If you don't want to let PowerPivot detect the relationships, you can explicitly define the relationship. Follow these steps:

  1. On the PowerPivot ribbon tab in Excel, choose PowerPivot window.
  2. Click in the StoreID field on one worksheet.
  3. Select the Design ribbon tab in the PowerPivot window.
  4. Click the Create Relationships icon.
  5. 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.

  • + Share This
  • 🔖 Save To Your Account