Forum Discussion
Creating a calculated summary table based on an existing table
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!
Create measure Catcount = Count(Catecory)
Use matrix visual with
row = date
column = catecory
values = Catcount
1 Reply
Create measure Catcount = Count(Catecory)
Use matrix visual with
row = date
column = catecory
values = Catcount