How to sum the last value for all the members - before the selected year WITH Filter?

[yanivvl0]

hi everybody ,

i had a previos question - see https://community.qlik.com/thread/207054?sr=inbox

responded beautifully by Gysbert Wassenaar , 

The thing is that there is a need to do further screening of the formula that produces the desired result: - after the calculation exists - we have to find occurrences of a particular status (say 90) only summarize them. You can see highlighted in yellow which from them - to summarize only those with a red X, Many thanks.

[Gysbert_Wassenaar · Accepted solution]

Why should the fifth row with P_NO_1 10253 be excluded?

[yanivvl0]

thanks again Gysbert , i didnwt see it ...    MUCH HELP 4 US !!

[yanivvl0]

Yess Sunny - it is . thanks !