Pivot table and defect tracking

[bam]

Hello,
I have a list of defect numbers, entered dates, and closed dates
(approximately 6000 rows).
All defects have entered dates, many, (but not all) have closed dates.
I see how to do a pivot table to produce defects entered by week and I can
change the pivot table to show defects closed per week.
I don't see how to show all weeks and display defects entered and closed for
each week.

Any suggestions appreciated,
Thanks
bmac