Month Over Month Comparison of string Fields

[dsharmaqv]

Hi

I have a requirement to compare string fields over the months for any change in the string value.

For Example :

I have to compare the status of countries and have to color the background if there ia any change in status.

For india status is "Hign" in May and changed to "Low" in June so I have highlight the change.

Month              Country               Status

--------------------------------------------------------

May                 India                    High

June                India                    Low

July                 India                    Low

May                 Japan                  Low

June               Japan                   Low

July                Japan                   Low

Can some one help me out . This is urgent!!

[sunny_talwar]

I know it can be frustrating when your discussions go into moderation, but try to restrict yourself from posting the same thing again because most likely the second one will end into moderation as well. Look at my response here: Month Over Month Comparison of string Fields