How to find data based on the value of previous month and current month

[#1]

Header 1	Header 2
Account	Rating
1001	A
1002	A
1003	A
1004	B
1005	B

Month=March

Header 1	Header 2
Account
1001	A
1002	B
1003	B
1004	B
1005	B

Month=April

Now I wants the count of account for april month who has Rating A in march month and change the rating from A to B in April month.In above example desired output is 2 as account(1002,1003) change the rating from A to B.

[#2]

Its difficult, I need some time to solve this...

[#3]

Check this out. I think it should solve your problem.

http://community.qlik.com/message/63017#63017

Best Regards,

Vishal

[#4]

Thanks Vishal....

[jagannalla]

Is there any month field in your tables..

[#6]

Yes, there is a month field and monthend id as well...

[jagannalla]

Try this it may helps you..

=Count(Aggr(Sum({<MonthField={"April"}>}Account),Rating))

[#8]

nice!