Creating a calculated summary table based on an existing table

[kdc02]

Hi,

I have a raw table (that contains other columns aside from these two):

Date	Categories
1/1/2023	Category B
1/1/2023	Category B
1/1/2023	Category B
2/1/2023	Category F
2/1/2023	Category F
2/1/2023	Category F
1/1/2023	Category G

Is it possible to create a new table that is a summary count of the raw table like this?

Date	Category A	Category B	Category C	Category D	Category E	Category F	Category G
1/1/2023	10	3	21	8	4	0	1
2/1/2023	4	7	23	5	4	3	5

Thank you!

[selvaskm · Accepted solution]

Create measure Catcount = Count(Catecory)
Use matrix visual with
row = date
column = catecory
values  = Catcount