Dynamic filter

[Mokhtar]

Hi,

Appreciate your support with regard to Excel dynamic filter “ Dropdown list”

Case need a daily report :

I have 4 branches “ Branch 1 , Branch 2, Branch 3, Branch 4 “

Under each Branch have 4 line of businesses “ Retail , B2B, Wholesalers , Shops “

For each line of business had sales manager , Supervisor , sales man

Under each sales man list of customers.

i need to have dynamic filter as follow
when i choose All Branches --> see
Retail --> Supervisor 1 --> sales man 1 ---> List of customers
--> Supervisor 1 --> sales man 2 ---> List of customers
--> Supervisor 1 --> sales man 3 ---> List of customers
--> Supervisor 1 --> sales man 4 ---> List of customers
--> Supervisor 2 ---> sales man 1 ---> List of customers
--> Supervisor 3 --> sales man 1 ---> List of customers
--> Supervisor 3 --> sales man 2 ---> List of customers
B2B --> Supervisor 1 ---> List of customers
Wholesalers
--> Supervisor 1 --> sales man 1 ---> List of customers
--> Supervisor 2 --> sales man 1 ---> List of customers
--> Supervisor 2 --> sales man 2 ---> List of customers
Shops
--> Supervisor 1 --> sales man 1 ---> List of customers
--> Supervisor 2 --> sales man 1 ---> List of customers
--> Supervisor 2 --> sales man 2 ---> List of customers

Thanks