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.
I know this is old, but it is easy to do. 1  Open the Pivot table wizard. 2  Select I will create the page fields. 3  Add the different ranges.  Select 1 for how many page fields you 1  want. Click on the first range, and then type in the page field name you want.  Finish the table as normal and then move the pivot labels to suit.