Hi Can any experts help me with below data.
I need the set expression to count the number of A1,A2, and A3 and group it.
Condition
if Attendance is 'NO, and Grade is 'A1' and if date id blank count 1
if Attendance is 'NO, and Grade is 'A2' and if date id blank count 1
if Attendance is 'NO, and Grade is 'A3' and if date id blank count 1
| Grade | Attendance | Date |
| A1 | NO | 01-02-2019 |
| A2 | NO | ___ |
| A3 | NO | 02-02-2019 |
| A1 | NO | ___ |
| A2 | NO | 04-02-2019 |
| A3 | NO | 05-02-2019 |
