Forum Discussion
Creating a Matrix
Hi How to make Table 2 based on data in Table 1. Table 1 contains accident data, Crash ID refers to a unique ID of a crash, Veh Type refers to the types of vehicles involved in crashes, ...
v-yanjiang-msft
Community Support
Community SupportHi Anonymous ,
According to your description, here's my solution.
1.Select the Driver column, then click Pivot Column.
Select "Veh Type" column in the Values Column option and select Don't Aggregate in the Advanced options.
Result:
2. In a matrix visual, put Responsible column in Rows, Victim column in Columns, Crash ID column in Values and select Count in the dropdown option, get the correct result:
I attach my sample below for your reference.
Best Regards,
Community Support Team _ kalyj
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.