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.
Creating the Pivot Table. 1  Highlight cells A2 to D12 2  . Click on the Insert tab of the ribbon. 3  Click on Pivot Table in the list to open the Create Pivot Table dialog box.  Choose Existing Worksheet for the location of the pivot 1  table. Click on cell D16 in the worksheet to enter that cell reference into the location line.