Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have the following columns in my pivot chart:
I have a filter called ActiveProjects applied on this chart. This column is calculated on the basis of ProjectStage.
An 'active' project might still be in-progress, but a resource could have stopped working on it. The ProjectEndDate column in the above datasheet is actually the Resource End Date for that project.
My requirement is that when ActiveProjects filter is selected, all the projects where there is an EndDate should be removed.
Can this be done? Any help would be appreciated!