Month over month counts Based on Status

Fri, 28 Mar 2014 17:44:59 GMT

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 --> 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 ......

Re: Month over month counts Based on Status

Fri, 28 Mar 2014 20:36:42 GMT

Any thoughts

Nicole-Smith — Mon, 31 Mar 2014 14:10:04 GMT

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.

Tue, 01 Apr 2014 10:39:29 GMT

thanks Smith.

I will look into this