Excel – Power Pivot

1. Convert to table and name the name, as following example named as “Products” Table

2. Excel options -> Add-ins ->Manage -> COM Add-ins-> Go -> turn on the powerpivot
3. Powerpivot -> Add to Data Model for all of the tables
4. Powerpivot -> Manage ->Diagram view -> connect the relationship
5. Powerpivot -> Manage ->Data view -> pivot table
The same process as simple pivot table

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.