How to create custom interactive filters on the same table with conditions

[Alvin7]

Dear expert,
I'm a beginner for ServiceNow,regarding the Custom interactive filters,could you please give some advice?Thanks in advance.

Requirement:
Use custom interactive filter to retrieve the component and it's sub-component
and display the result on Dashboard.

Currently,in the dashboard,there is already a component reference filter cannot meet the above requirement(this filter can only retreive the input component itself).

Sample data structure:

The componet and sub-component stored in the same table,the table strutcture like below:
Record 1:
<sys_id>624e8e221bc233401ead7403dd4bcb43</sys_id>
<u_component>AC</u_component>
<u_parent/>
Record 2:
<sys_id>a24e8e221bc233401ead7403dd4bcb46</sys_id>
<u_component>ACCO</u_component>
<u_parent display_value=""AC"">624e8e221bc233401ead7403dd4bcb43</u_parent>
If input the component with name "AC",the above 2 recoreds(component AC and it's sub-component ACCO) should be retrieved.

Following the below instructions,UI macro(system UI>>UI macro) and Dynamic content(Content Management >> Dynamic) was created,it still does not work correctly.
1)https://developer.servicenow.com/connect.do#!/event/creatorcon18/CCW1161
2)https://docs.servicenow.com/bundle/orlando-performance-analytics-and-reporting/page/use/dashboards/concept/c_CustomPublishers.html

Question:
For this issue,where should I start from?
Can you give me some advice?
How to find the component and it's component in the Dynamic content?

[Arlene H]

Thanks Adam.  I was looking for the same requirement and initially thought the solution was to use a dynamic filter. But you are right, a Cascading Filter will enable me to create a filter on the same table I'm reporting.  If anyone's interested this is how I did mine:

My report uses the table:  sn_hr_core_profile  (with many criteria inside)

Requirement:  Filter this report by Employee number

Solution:

• I created a report using the table:  sn_hr_core_profile.
• I then created a Cascading Filter (see below screenshots).
• I then set edited the Widget (The main report) to follow Interactive Filter.

Then on that Cascading Filter, I set the target table and field:

I got this after: