I am creating filter for dashboard using Spreadsheet OCA to support. But when I choose "Parent department", it's only show record in "Parent Department". 

But I hope when I choose "Parent Department", it's auto show record in "Parent Department" and "Children Department".

Ex: I have Sale, Sale A, Sale B departments. I want when I choose "Sale" in filter, it's show records in "Sale" and "Sale A" + "Sale B".

Please help me ...