Please follow the Steps in attached. Calculation 6 is Combined Calc which I used to get There.Calculation 5 will also return same values.
If it Helps, Pl Mark it Helpful and CORRECT to Close Thread
Next Value Condition Based.twbx 16.5 KB
Thank you very much Deepak! This is looking great.
Would it also be possible to get this result if the table wouldn't have the column 'row number'? I couldn't modify your great calculation in a way that worked.