I need the Total Reviews which are still Entry and Exit stage, the Decision 'Pass' states phase is passed from Phase Entry Review and entered into Phase Exit Review.
uploaded the sample excel.
but i need to get the projects which are not passed , in the above data 1003 and 1004 are only 2 projects to be showed and i,e
1003 is in Exit review and 1004 is in Entry review.
X axis must be Phase Review, Y axis will be Numbers.
I need to count total phase review which are in Entry phase review and Exit Phase Review
*Condition is Don't count the review Which is "Pass". Pass means the review has passed and u you can move to next phase review.
i have only 2 phase reviews and phase Entry and Exit, If Entry is pass then it moves to Exit , and if exit is pass it is Released.
Process is like this