Hi, you can use string pattern matching or sub string method to form groups and apply filter on them. I used "find function" to find the sub string to find the department and subject of student.
Below is a snap of calculative field to group students by Department.
![](https://www.edureka.co/community/?qa=blob&qa_blobid=3829524517619825005)
Below is a snap of calculative field to group students by Subject codes.
![](https://www.edureka.co/community/?qa=blob&qa_blobid=3732066817532350284)
Drag an drop both groups in the filter shelf to apply filters.
Sample visualization after applying filters.
![](https://www.edureka.co/community/?qa=blob&qa_blobid=4329013512512683225)
Hope this helps you.