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
