If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Migration matrix

Started by Imre, 02 Jul 2019 09:45:29 AM

Previous topic - Next topic

Imre


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:



https://cdn3.imggmi.com/uploads/2019/7/2/0a36f5293422530f01aca084c4a88032-full.jpg

The data behind the 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

I got the solution. I just need an other column with the T0 data.