Hierarchical Table - how to include categories when filtering on details|General Excel Questions & Answers|Excel Forum|My Online Training Hub

I have a table that contains three levels of data - effectively "category", "sub category" and "item". Something like this:

 Row 1: Category 1

    Row 2: Sub category 1.1

       Row 3: Data item 1

       Row 4: Data item 2

    Row 5: Sub Category 1.2

       Row 6: Data item 3

       Row 7: Data item 4

Row 8: Category 2

    Row 9: Sub category 2.1

       Row 10: Data item 5

       Row 11: Data item 6

       Row 12: Data item 7

Each row has columns such as "Status", "Owner" "Approver" etc (which only apply to the individual data items) and I have slicers so that I can easily filter on such columns. However, because the category and sub category rows do not have this data completed The category and sub-category rows associated with the filtered data items are lost.

Is there a way to show "hierarchical" or "parent" rows so that, for example, if a filter selects data item 3 in row 6 it also displays Row 1 and Row 5 in the example above. I realise this may be a coding requirement rather than a filtering requirement but I'm not sure where to start).

I have attached some example data to make it clearer. Note the three columns called Team, Family and Item - "Item" is always zero if a category or sub-category, all data items have a value >0 in "item" - not sure if this helps.

If anyone has any ideas please let me know...

Thanks, Graham