Need support please

Hi, If i have the below Database, and I need to make a report where i can have a filter per City, which means if I filter for CIty 1, he will give me the 2nd View:   Database:   View 2: ...