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.
How to create a pivot table report. Next: Add categories & fields in a pivot table. To create a pivot table report from data in your spreadsheet, follow these steps: 1  Open the spreadsheet that contains the data you'd like to use for your pivot table. 2  From the Data menu, select Pivot table report.