Hi,
Is it possible to create a migration matrix by using the same column for eg. Status T0 and Status T1?
An example maybe shows my needs better that words:
| Status changes from April to May |
|
|
|
|
|
|
|
|
|
|
April (T0) |
|
| May (T1) |
Good |
Worse |
Worst |
Total |
|
| Good |
25 |
2 |
1 |
28 |
|
| Worse |
4 |
73 |
0 |
77 |
|
| Worst |
0 |
7 |
22 |
29 |
|
| Total |
29 |
82 |
23 |
134 |
|
|
|
|
|
|
|
The data behind this example would be a column "Date" with the values "April" and "May", a column "Status" with the values "Good", "Worse", "Worst" and one column with values. I would filter the values to my preferred Date.
I tried it with a crosstab but could not make it work.
Do you have any ideas?
Thanks.
------------------------------
Imre Pardi
------------------------------
#CognosAnalyticswithWatson