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.

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