automatic filter on Department tasks
for my automotive change projects I created a large PSP made from a Project WBS which contains information from the change.
The PSP contains 8 main phases (Phase 1 initiation to Phase 8 project closure), each phase has at least one or more goals and these goals contains tasks to be done to reach that goal. All tasks are linked to responsible departments (f.i. R&D, Quality, Sales, PM, Production, Logistics, Controlling, Procurement, ...) .
If all tasks in the previous phase are completed (=100%) the phase is not seen any more (done with a power filter) and the tasks of the next phase and the next phase must become active. The tasks from this current active phase must be done next.
Problem: Having what is described above I would like to see (maybe on an extra page) all departments lined up each in a single box side by side , and below each department-box listed downwards should list all open tasks for the active phase.
If the next phase gets active, the tasks of that phase must be listed below the corresponding department .
Thanks for your ideas and help