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