What is the difference between a vision statement and a mission statement? What is the difference between sight and vision? What is the difference between a dream and a vision?
1 If the column you want represented in your pivot table does not already exist in the source data worksheet, you will need to insert a column by right clicking on an existing column and choosing Insert Column from the popup menu.  If you added a column to your source data, populate that column with the relevant data.
You can add these tables to the Data Model in Excel, create relationships between them, and then use the Data Model to create your PivotTable. Here's how you'd import multiple tables from a SQL Server database. Make sure you know the server name, database name, and which credentials to use when connecting to SQL Server.