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