How to fulfill the requirement?

[#1]

Hi All,

Please see the below requirement how to approch this means which chart or text object.

Input:

Loaction	Year	Month	Price	profit
Hyderabad	2014	10	100	10
Hyderabad	2014	9	90	9
Bangalore	2014	10	150	15
Bangalore	2014	9	170	17
Chennai	2014	10	195	15
Chennai	2014	9	190	17
Kerala	2014	10	200	20
Kerala	2014	9	300	15

Requirement:

Total we have four colors red,green,orange and yellow. here we will compare Current month VS Last month

1.if current month price & profit is higher than last month then that location goes to Green color

(price=high & Profit=high------------Green)

2.if current month price & profit is lower than last month then that location goes to Red color.

(Price=low & Profit=low------------------Red)

3.if Price=High  & Profit=Low-----------Yellow

4.if Price=Low & Profit=High-------------Orange.

This location places may vary every month based on value

How to write conditions ?????????????

How to approach the way to develop this????????????????

Output:

Please find the attached file for see the output format.

Kindly give any ideas, appreciable.

Thanks & Regards,

Ashok.

[#2]

Hi,

No no not like that needs to show all locations not only 4, all locations should come.

my requirement is which are locations comes under green should come on one Green box(i mean block) same like rest of the colors .

for more clarity please find attached screen shot.

Thanks,

Ashok.

[#3]

Hi

Please see the attachment.

Thanks

Sovan