How to filter based on WBS date in Primavera P6

We are working on a project that includes four buildings, as shown in the image below:

how-to-filter-based-on-wbs-date-in-primavera-p6-1

Our goal is to filter and identify which buildings are scheduled to start within the next three months (December, January, and February).

To do this, we can create a filter based on activity dates:

how-to-filter-based-on-wbs-date-in-primavera-p6-2

Primavera P6 will then display the following result:

how-to-filter-based-on-wbs-date-in-primavera-p6-3

According to this filter, Building 1 and Building 3 are scheduled to start.

However, the finish dates for Building 1 and Building 3 at WBS-level are incorrect. This is because P6 displays WBS-level dates based on the currently visible activities in the layout.

How can we display the correct start and finish dates for each WBS?

Primavera P6 does not support filtering directly based on WBS dates. This is where the “WBS Summary” activity type becomes useful.

We can create a WBS Summary activity for each building:

how-to-filter-based-on-wbs-date-in-primavera-p6-4

Each WBS will now include a summary activity that mirrors the overall schedule of that WBS:

how-to-filter-based-on-wbs-date-in-primavera-p6-5

This allows us to filter WBS elements just like regular activities:

how-to-filter-based-on-wbs-date-in-primavera-p6-6

Now, when we apply the filter, Building 1 and Building 3 display the correct finish dates.

Leave a comment

Create a website or blog at WordPress.com

Up ↑