Creating a Matrix

Thanks for your kind assistance, could I ask how to create the following table

from give Table 1

Hi 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.