More Pivot Tables

• Section 5.4
• I am using a modified cereal workbook.
• Databases are the way to store information.
• But database people don't like storing duplicate information
• So they break things down into tables.
  • Notice the table from chapter 4.
  • But there are two more tables at the bottom of the page.
    • One for company names.
    • One for if the cereal is served hot or cold.
• We need information from all three tables to do an analysis.
  • It would be annoying to sort by company as K, C, G, ...
  • And also by H or C, these don't mean anything.
• So excel provides a relationship
• Relationship's are built between tables
  • It is probably worth naming the tables as you create them.
  • After that create a relation
  • The data we want to replace in the main table is called a key
  • This should match the data in another table.
  • Data tab, Data Tools group, Relationships button.
  • Build the relationship between tables.
  • Make sure you select the corresponding key fields.
• When building the pivot table, make sure that you check the Add this to the Data Model box.
• When working with the pivot table, make sure you check the select All in the PivotTable Filed.
• Use the corresponding fields.