Display training course does not join yet.

[Bigboss_Nguyen]

Hello, I have 2 tables: Training frame and training data. 

Training data: training history of trainees.

/ Training frame : Define level of courses

Employee need to study all course based on their position from level A to level D. Note: Level of course and level of band is same.

Ex: Employee E1 band A, so he needs to study all course A1 → A5 and for promotion to band B, he also needs to study all course B level. When I use filter, expect result as below:  

1. Display table with all course completed and need to study.

2. Also, display external course if already completed

3. Index dynamic based on filter

Link sample here: Training data sample 

Please help me resolve this issue. Thank you so much.

[Bigboss_Nguyen]

@amitchandak @Ritaf1983 Could you provide a solution for me? Many thanks

[Bigboss_Nguyen]

Please help me figure out a solution. Thank you.

[Bigboss_Nguyen]

I've tried various solutions, but they're not producing the expected results 😞