Count based on multiple columns

[jt422605]

Hi,

I need to count certain students based on the their category and the count should be posted on their 'Master's ' row.  can someone please look  in below..  - last column is the expected answer. ...

ID	Item	Student	Category	Master_Ref	Sub Count
21	10	Master-1	Master		6
22	20	ST-2	SUB	10
23	30	ST-3	SUB	10
24	40	ST-4	SUB	10
25	50	ST-5	SUB	10
26	60	ST-5	SUB	10
27	70	ST-5	SUB	10
28	80	Master-2	Master		2
29	90	ST-7	SUB	80
30	100	ST-8	SUB	80

[SL2]

hi Sunny, I have a quite similar question but I don't know how to solve. Could you please help me with this?

https://community.qlik.com/t5/New-to-Qlik-Sense/find-records-with-same-dimensions/td-p/1816231

Much appreciated!