I have Dimension as Geo_ID which is a cyclic group with Nation, REGION_ID, DISTRICT_ID and TERRITORY as fields. Now even if i am selecting any particular geography level say a particular district or a territory then the selected is highlighted but other district or territory are also listed with their values. But when i am going one level down with a particular district selected then all the territories in the nation are coming. I want only those territories to appear which are there in the selected district. How can i change my expression to do that ??
I don't know if I missing something here, but in general if you want your sum expression to respect which DISTRICT_ID you actually have selected, you should not have a set expression with DISTRICT_ID= in it, because that makes that expression disregard any selections in DISTRICT_ID.
