Filtering set values to zero does not remove the column
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 .
