
This Excel tutorial explains how to create Relationship and create Pivot Table using PowerPivot.
You may also want to read:
Create Relationship in Microsoft Access
PowerPivot in Excel
In Excel version 2016, PowerPivot is pre-installed and you can see the option in the ribbon tab.
For previous versions of Excel, some versions cannot support PowerPivot. If you are not using Excel 2016, I recommend you to google search how you can install PowerPivot in your version, you may need to...
Read More