Need Help in Set Analysis

[agni_gold]

Hi I have created the data model in which i have created the link between ZONE_Id,MAIN_ID ans SUB_ID .

but my problem is to when i select a ZONE_ID there will be selection for MAIN_ID and SUB_ID both but i want sum of the  MAIN_ID but not to select the all SUB_ID who lie in MAIN_ID

But those MAIN_ID  vale who dose not have any SUB_ID  i also need sum of these SUB_ID

how can i do in set analysis.

[its_anandrjs]

Can you elaborate more please with any example for this.

Regards,

Anand

[agni_gold]

Hi I am attaching the sample data

Please check I have 4 tables

Zone

Site

Pump Group

Pump

Zone is Master if i select the zone id the corresponding sites are selected in my data model and corresponding to these site Ids Pump Group and Pumps are selected.

But the problem is here when pump group and pump are selected the i have to show in my dashboard , firstly Pump group but it is possible some pumps are lie in selected pump group so i have not to show the pumps those are lie in pump group .

But those pumps which doesn't have any pump group , i have to show in dashboard.