Change in Values

[#1]

TABLE1:

Id	Name	Status	Risk	Date
100	ABC	Open	Low	10/1/2014
100	ABC	Closed	Medium	3/2/2014
200	DEF	Open	Low	1/1/2015
200	DEF	Open	Medium	1/2/2015
200	DEF	Closed	High	1/3/2015
300	XXX	Open	High	5/6/2015
300	XXX	Open	Low	7/7/2015
300	XXX	Closed	High	8/9/2015
400	YYY	Open	Low	1/2/2015
400	YYY	Closed	Medium	2/2/2015

I would like to see where the Risk  for a Id changes from when we first receive the Id's risk  in the above table to when their Status changes to Closed    

How many Ids changes risks/ For a closed id in the above table - has the status changes since Open? A flag needs to be added to know rish changes or not(y/n)

Help me on the above?

[trdandamudi]

It is not clear.. Can you give us an example with the output you are expecting...

[florentina_doga]

hy

hope this help

[#4]

Any further Ideas please can anyone help ?

[#5]

Hi

The flag we can show it as yes or no

If the risk changes from open to closed we need display it as Yes as a Flag

[settu_periasamy]

Hi,

Can you post the expected output for your posted table?