Pivot Table

Hi,

Attached is the test file I am currently working on.

For each dates, 3- 5 staffs were involved for the case specific category. Need to create a report every month to send to payroll for each staff who involved with the category type and the dates they were involved. Want clarification, is this the right way to record the data to extract desired out come?

Report 3 - I am trying to get dates for individual staff for the tasks they involved. Tried using with pivot table and couldn't able to get the list of dates for each staff.( report needed for each month)

Any suggestions and ideas, greatly appreciated.

Thanks.test1x.jpg