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.
Place the cursor on any cell in the table. Click Power Pivot > Add to Data Model to create the linked table. In the Power Pivot window, you will see a table with a link icon, indicating the table is linked to a source table in Excel: If the model already contains tables, you have one more step.