problem in Drill Through

Thanks for the response but still it is not working at some level.

let me brief you

we have 4 tables:

table 1 has country, city, and area. where area are three: Residential, Mall, office

table 2 has an area, building, floor, sector. where the area is 'Residential'

table 3 has an area, building, floor, sector. where the area is 'Mall'.

table 4 has an area, building, floor, sector. where the area is 'office'.

in the report, I want to show the map on the first page- there is drill down from country to the city. 

on the 2nd page, We want to drill through from city to all area's. where it should show only areas which come under that city.

and on 3rd page, drill through from area to building or floor. then floor to sector

 I tried to implement by combining all data of table 2, 3, and 4. and all drill-down and drill-through features working fine except sector. 

for example, when I drill through from 6 floor to sector it shows all sectors of the 6th floor of all Area. where as it should show sectors of 6 floor of particular area

please advice why it is not working.