Issue with dependent Data Validation

Hi,

There are 2 types of query under query type that is Benefits & HR Operation , when I select any one, under sub query type only the queries should display that belongs to query type. I have done this. But when I select query type as “benefits” and sub query type as anything as in the table then in last column under “call activity” all call activity should display (activities like – inbound, outbound, Outbound or VM call back, VM Retrieval, Forwarded to CAST, Escalated to ABC, Escalated to XYZ)

Attached the sample sheet for your reference. if possible do it with this sheet and post it.

Thanks!