Pivot Tables
 

I would like to make a table that has the following colums and data:

Emp. No
Emp Name
Department
Section
Job Title
Absence Reason
Working Days Lost
Count of Employee No
Sum of Working Days

Can anyone assist? I was able to make this work in 97 but the same
techniques do not work in 2003.

Thanks

Pivot Tables
 

In article ,
says...
I would like to make a table that has the following colums and data:

Emp. No
Emp Name
Department
Section
Job Title
Absence Reason
Working Days Lost
Count of Employee No
Sum of Working Days

Can anyone assist? I was able to make this work in 97 but the same
techniques do not work in 2003.

Thanks

How do they not work? While some of the implementation steps have changed,
the concepts and ideas behind a PivotTable have essentially remained the
same.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

Pivot Tables
 

It is advisable that you create two different excel sheet with different
fields and use them with one pivot table. This will give greater control for
navigation. You can interact better using this technique within one pivot
table.

Challa Prabhu

"Mary" wrote:

I would like to make a table that has the following colums and data:

Emp. No
Emp Name
Department
Section
Job Title
Absence Reason
Working Days Lost
Count of Employee No
Sum of Working Days

Can anyone assist? I was able to make this work in 97 but the same
techniques do not work in 2003.

Thanks