I am using the pivot table wizard to combine two tables of data. The contents of the tables are as follows:
Worksheet 1: Period, Customer, Net Revenue
Worksheet 2: Period, Customer, Hours, Time Cost
Each column is labeled as a field under the names shown. When the pivot table is created i only see the following in the Field Box. Row, Column, Value, Field 1, Field 2, Field 3. I am not sure why I have one column field when the column fields should be: Period, Hours, Net Revenue, Time cost. The row field is Customers.
I want to insert calculated columns but unless i can get the field data seperated it will not work. Any assitance will be greatly appreciated.
Worksheet 1: Period, Customer, Net Revenue
Worksheet 2: Period, Customer, Hours, Time Cost
Each column is labeled as a field under the names shown. When the pivot table is created i only see the following in the Field Box. Row, Column, Value, Field 1, Field 2, Field 3. I am not sure why I have one column field when the column fields should be: Period, Hours, Net Revenue, Time cost. The row field is Customers.
I want to insert calculated columns but unless i can get the field data seperated it will not work. Any assitance will be greatly appreciated.