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