H
Heera
Hi All,
I am using Excel 2007.
I have the following fields in the column.
Emp ID
Name
Supervisor
Quantity
Amount
I want to create a pivot table in which I want the data in the
following format.
Supervisor Name Emp ID Amount
Heera Komal 111 30
Heera Mike 112 40
Heera Tony 113 50
The important thing is I want Supervisor, Name & Emp ID in all the
rows.
This is not posiable in Excel 2003 is it posiable in excel 2007.
Regards
Heera
I am using Excel 2007.
I have the following fields in the column.
Emp ID
Name
Supervisor
Quantity
Amount
I want to create a pivot table in which I want the data in the
following format.
Supervisor Name Emp ID Amount
Heera Komal 111 30
Heera Mike 112 40
Heera Tony 113 50
The important thing is I want Supervisor, Name & Emp ID in all the
rows.
This is not posiable in Excel 2003 is it posiable in excel 2007.
Regards
Heera