Set Analysis Help

[#1]

Hey,

I am having difficulty creating a couple statements to help work with my current data set.  First objective is to have the blue bar be the sum operating score between the company, sector, and sub-sector.  The second is to have the red bar be the avg operating score between the company, sector, and sub-sector selected.

Restrictions -

1. Company must be selected first.

2. Then we need to benchmark it against overall average and then give a user the option to drill down by the sector and sub-sector.

Please let me know if you need more detail!  I really need some help with this!

Example,

If I select Sector Health and Sub-sector Health - Phama, my red bar should reflect the avg between the two selections (2) and my blue bar should reflect the total sum of the selections (4)

[Kushal_Chawda]

Please post the sample app or data