We have schedules developed by contractors that have WBS's utilizing a standard template developed for the project I'm involved with. Since we have approximately 15 projects set up using this template, we wanted to filter activities wherein work is occurring under a particular Stage across all the projects. I can filter a WBS by just stating WBS Name equals "Stage X". The problem is you only get the activities under the Stage X in question, you do not get the activities from WBS's within the Stage.
I reached out to Oracle and they came up with a solution to create a UDF, then perform a global change where the UDF equals the WBS Name, then run a filter on the Stage, but it is still the same problem. To try and utilize a filter of activities for "WBS is under Stage X" would be monumental and a total pain to perform.
Have you encountered such a situation and do you have a possible solution? I am attaching two pictures: one of what the filter does when WBS Name equals Stage X and one of what we really need.
