How to create the dependent list of filters ?

In the attached excel file, how to create the dependent list of filters between X,Y and Z? Filters X is the parent while Y and Z are the childrens.
If I select any value in the filter X, it should automatically filter out the values in Y and Z filters.

Also how can I add 'ALL' value into the filter values so when I select 'ALL', it selects all the values in the list.

Please advise

Fill in the blanks in column A for starters, only the formulas for Company1 in C5:E5 can see "ABC" in A5, the formulas in C6:E12 for companies 2 to 7 are looking for a blank type because the cells are empty.

Once you've done that, your existing formula should show all when the filters are empty. If you specifically want to have the keyword "All" in the dropdowns, then add that to your dropdown list and to the sumifs formulas.

Can you please show me how you can do it in the excel file ?

Thanks!

Taking a second look at your file, the answer to that would be no. Your file is an absolute mess that needs sorting out before it will be possible to do anything.

As an alternative that will take less effort to set up and maintain, try creating a pivot table from your data dump.

First, use the DataDump (2) sheet as the source, because that sheet is formatted as a structured table it will work better than the one which is not.

Click on any cell in the table (the bit with the blue borders).
Next go to the 'Insert' tab on the excel ribbon and click on 'PivotTable' (on the left). In the pop-up box, click OK.
Now, in the box on the right you will see the column headings from your table listed with checkboxes. The next part is to drag them into the 4 smaller boxes below the list as follows.

X, Y and Z, drag to Filters.
Types and Company, drag to Rows
Month, drag to Columns
Measure, drag to Values.

This should now give you a formatted table of results from your data dump, similar to the one you were trying to create.