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

There's no change in that feature in Excel 2007 pivot tables. The
headings will appear only once, not repeated in each row.

Heera wrote:
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


--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com

Hi,

It is possible in 2003 and 2007 - but you need to think outside the box!

1. Put the Supervior, Name and Emp ID in the Row Labels area (not the Column
Labels area).
2. Put the Amount in the Values area
3. Choose PivotTable Tools, Design, Report Layout, Show in Tabular Form
4. Right-click the Supervisor field and choose Field Settings, Subtotals -
None
5. Repeat step 4 for the Name field.

If this helps, please click the Yes button.


--
Thanks,
Shane Devenshire


"Heera" wrote:

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

Hi,

It worked fine......thank you.