In my excel, project breakdown sheet. There are 37 projects. Its fine. The problem is when I do the pivot table for Incident (LOPC,SPILL, MINOR FIRE, MAJOR FIRE, MINOR PD, MAJOR PD, FAC, MTC,RWC )named Incident Type. The project from 37 become 6 only. It only take project that has incident. I want all the project so that I can create the selection but now only has 6 project.