Hello,
I have this data set :
User | Course | progress | Discharge date | Discharge |
U1 | C1 | 50% | - | No |
U1 | C2 | 30% | - | No |
U1 | C3 | 100% | - | No |
U2 | C1 | 0% | 01/03/2020 | Yes |
U2 | C2 | 19% | 01/03/2020 | Yes |
And each user has his boss and manager , and I want to show a table of the bosses , managers with their employes and counting how many courses are they enroll and how many of them have they finished... And I have a filter which is Discharge yes or no, so if I choose Yes i Would like that the row belonging to this employee with his boss and manager is deleted from the table, instead the values are set to zero.
Manager | Boss | User | Total courses | Completed | Discharged date |
M1 | B1 | U1 | 2 | 0 | - |
M1 | B1 | U2 | 3 | 2 | 01/03/2020 |
M1 | B2 | U3 | 0 | 0 | - |
M1 | B2 | U4 | 12 | 2 | - |
M1 | B2 | U5 | 3 | 3 | - |
so in the exemple below instead of removing the U2 that is discharged by the filter It set all the values of Total Courses and Completed to zero .
Kind regards,
Marta