to capture movements in data between different dates

[mohdazhr]

Hi all ,

I have got the similar data and multiple iterations of this across several dates. What i would like to capture is the movement for ID's between 2 different dates (allow the user to select the variability of comparison dates like 4 weeks , 12 weeks etc )  and categorise them under

positive movement

negative movement

no Movement

as an example i have the following data

date	id	status
02/04/2015	a1	01
03/04/2015	a1	02
02/04/2015	a2	02
03/04/2015	a2	01
02/04/2015	a3	01
03/04/2015	a3	01

I would like to show is when the user selects  Positive movement

id	current status	Last week status
a1	02	01

when user select negative movement 

id	current status	Last week status
a2	01	02

when user selects no movement

id	current status	Last week status
a3	01	01

[lindelanifakude]

@mohdazhr  did you find the solution for your post, I'm looking a solution something similar to this?