Need help in set analysis

[musketeers]

Hi,

I have a requirement like.

I have data like below

Region	Sub Region	Country	year	Product	Quantity
R1	SR1	C1	2013Q2	P1	200
R1	SR1	C1	2013Q2	P2	201
R1	SR1	C1	2013Q2	P3	202
R1	SR1	C2	2013Q2	P1	200
R1	SR1	C2	2013Q2	P2	201
R1	SR1	C2	2013Q2	P3	202
R2	SR2	C3	2013Q2	P1	200
R2	SR2	C3	2013Q2	P2	201
R2	SR2	C3	2013Q2	P3	202
R2	SR2	C4	2013Q2	P1	200
R2	SR2	C4	2013Q2	P2	201
R2	SR2	C4	2013Q2	P3	202

In above table I have Region, Subregion and Country data for some year quarter and some products. Now I have to create a chart where I have to compare the sum of Quantity of selected Region or Sub region or country with some other region or subregion or country. For this we have another table like

Country	Compare1	Compare2	Compare3
R1	SR1	R2	C1
R2	SR1	R2	C2
SR1	SR1	R2	C3
SR2	SR1	R2	C4
C1	SR2	R2	C4
C2	SR2	R2	C3
C3	SR2	R2	C2
C4	SR2	R2	C1

So according to above second table if user has selected region R1, then I have to display a chart with the sum of quantity for Region R1, sub region SR1, region R2, and country C1.

Is there any way to solve this issue. Please help me in this part.

Thanks

Rajneesh

[Anonymous]

Please have a look at my example. Hope that's helps.

Cheers

iSam