Previous 5 Months of data with Diffrent logic

[Kushal_Chawda]

Deal All,

I have below requirement & I am facing problem to achieve it. I would appreciate for any help.

I have data look like  

ID	Month	Status	Amount
1	Jan-13	L	100
1	Feb-13	L	120
1	Mar-13	L	140
1	Apr-13	F	160
1	May-13	L	180
1	Jun-13	F	200
2	Jan-13	L	220
2	Feb-13	L	240
2	Mar-13	F	260
2	Apr-13	L	280
2	May-13	L	300
2	Jun-13	L	320

What I need is, I want to show all Previous 5 months of ID in report for particular month. Suppose when I select Jun-13, report should display IDs from Feb- 13 to Jun-13. This is fine for me. But, problem is explained below

I don't want IDs where status is 'F'. Problem is that one ID can be present in all previous month but I need to consider the status of current month and bases on that I need to filter the result.

For eg. ID=1.. In Jun-13 this ID should not be there in report as Status  is 'F', but when I select May-13 it should be there because current month status is 'L'.

In short I need all the IDs of previous 5 months and need to consider the status of current month.

I hope requirement is clear..

[MK_QSL]

Please check enclosed file.

[Kushal_Chawda]

Thanks for your reply.

But when I select Jun-13 It's showing zero, but there should be ID 2 for Jun-13

[MK_QSL]

Like this?

[Kushal_Chawda]

I will apply the same on my actual data and I will let you know.