Suppress Values in Pivot Table

[yashcena]

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!

[pradosh_thakur]

create a field in the script

if(len(trim([Project End Date]))>0,0,1) as active_project_flag

use active_project_flag = 1 in the set analysis or in the if condition.