Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Can you elaborate more please with any example for this.
Regards,
Anand
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.