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.
In a new sheet (where you want to create a new pivot table) press the key combination (Alt+D+P). In the list of data source options choose Microsoft Excel list of database. Click Next and select the pivot table that you want to use as a source (select starting with the actual headers of the fields).