is this possible?????/?????????

[#1]

Hey All,

Can anybody solve my prob.

the prob. is that I have table called Customer and it having fields named test_name & Region & sales & further more.

Example:-

Test_name	Region	Sales
test1	R-1	12000
test2	R-1	10000
test3	R-2	6000
test4	R-1	8000
test5	R-2	4000
test5	R-2	7000
test6	R-1	11000

Now what i want to do is to plot a chart that show Top 3 Test_name of both Region i.e Top 3 Test_name of 'R-1' and Top 3 Test_name of R-2 in a single chart

note:- Top 3 selection are based on sales value.

Plesae help me out.

Which chart is suitable and how can i plot.....

Thanks & Regards,

Binod Kr.

[rahulgupta]

Hi,

Kindly use Rank() Function

Regards