Picking data based on more than one dropdown options

Hello there,

Yet another obstacle I'm having trouble with, to which I know without a shadow of doubt you guys can help me with.

Any help will be much appreciated.

I am trying to source out a stream of data based on 3 dropdowns in the front sheet (attached). The dropdown can change criteria from user to user, e.g. client one can filter by Region only, Client 2 can filter to show Region and Segment and cluster and finally a Client would want to view the data as is (no Dropdown is selected). I've shortened the data source to view only a couple of lines, but there are 11000 entries. these entries consists of "Open" and "Lost" Values, which is also criteria i guess. Therefore two separate table will have to shown. I have tried to illustrate the result in the "Result" tab. Please do let me know if I'm unclear of what I'm trying to achieve.

I thank you in advance

F