To identify change of value in a column in same table based on month

[amar_nath_etta]

Hello,

I need some support to resolve below mentioned issue.

I need to identify change of Rating of a column value based on any selected  2 months based  on its rating in set analysis.

user will be able to select any 2 month of the list , and the count of unique id should be displayed based on Rating condition.

Rating condition: for any id we need to identify change in Rating value between selected 2 months.

Suppose user selects Jul as previous and Oct as latest month in selection.

then the count of unique id on change of rating to be counted.

ex: 103  in Jul rating is H

      103 in Oct rating is  VH

so there is change in rating of that id  and we need to exclude records which have no change in rating for month to month.

I have data as below:

Uniqueid	Month	Status	Rating
101	Jul-18	Open	H
102	Jul-18	awaiting	L
103	Jul-18	Open	H
104	Jul-18	awaiting	H
105	Jul-18	closed	L
106	Jul-18	closed	VH
107	Jul-18	inprogress	M
108	Jul-18	inprogress	M
109	Jul-18	Open	VH
101	Sep-18	Open	H
102	Sep-18	awaiting	L
103	Sep-18	Open	VH
104	Sep-18	closed	M
105	Sep-18	inprogress	M
106	Sep-18	inprogress	VH
107	Sep-18	Open	M
108	Sep-18	inprogress	M
109	Sep-18	Open	VH
101	Oct-18	awaiting	H
102	Oct-18	closed	L
103	Oct-18	closed	VH
104	Oct-18	inprogress	M
105	Oct-18	inprogress	M
106	Oct-18	Open	VH
107	Oct-18	Open	H
108	Oct-18	awaiting	L
109	Oct-18	Open	VH
110	Oct-18	closed	M

[amar_nath_etta]

need to solve it using set analysis.