Month over month counts Based on Status

[#1]

Hi Folks, I have the data like below:

ID,Status,Month

1,Approved,Dec-2013

2,Pending,Dec-2013

3,Disapproved,Dec-2013

4,Pending,Dec-2013

5,Disapproved,Dec-2013

1,Approved,Jan-2014

2,Approved,Jan-2014

3,Pending,Jan-2014

4,Pending,Jan-2014

6,Approved,Jan-2014

7,Pending,Jan-2014

8,Disapproved,Jan-2014

3,Approved,Feb-2014

4,Pending,Feb-2014

6,Disapproved,Feb-2014

7,Approved,Feb-2014

8,Pending,Feb-2014

9,Disapproved,Feb-2014

10,Pending,Feb-2014

11,Approved,Feb-2014

I need to create the Straight table like below:

Status	Current Month	Previous Month	Added	Deleted	Status Changed
Approved
Disapproved
Pending

Status --> Dimension (Bolded values)

Current Month --> Count of ID's in the current month ( if nothing selected on Month, take the Max month)

Previous Month --> Count of ID's in the previous month (Current Month - 1)

Added --> Count of newly added ID's in the Current Month when compared to previous month

Deleted --> Count of deleted ID's in the current month when compared to previous month

Status Changed --> Count of status changed ID's in the current month when compared to previous month

Any thoughts how to get this table ?

Thanks in Advance ......

[#2]

Any thoughts

[Nicole-Smith]

Have a look at the attached .qvw file.  The only thing I didn't implement was Status Changed because I don't understand how that is supposed to work.

[#4]

thanks Smith.

I will look into this