How drawing a Matrix showing number of changes between a current and previous Class

[michele_stenico]

Hi,

I start from this kind of Input Date

NDC,Data,Class
1,2020/01/01,A
1,2020/02/01,B
2,2020/01/01,A
2,2020/02/01,A
3,2020/01/01,C
3,2020/02/01,A
4,2020/01/01,B
4,2020/02/01,B
];

I would like  to count the number of Class Changing of my Customer and show the results in a matrix like this.

		Current Class
		A	B	C
Previous Class	A	1	1	0
B	0	1	0
C	1	0	0

I could calculate the previous Class in the Load Script, using previous function, but I would like to be able to do it in the presentation, may be using additional dimension (e.g Class_Prev, Class_Cur).

Could you help me ?

Michele

[michele_stenico]

Sorry, the example table was badly posted, that is

             A        B           C

A          1        1           0

B          0        1           0

C          1         0          0

thanks