Forum Discussion
Calculate columns which are identified on rows
Hi killingaxe,
For your output, you could get it without creating a calculated column.
Actually ,the calculated column is not dynamic so you can't get the output when you filter on US.
You could try to follow the steps below to get your desired output.
1. You should create the relationship of the two table so you need to unpivot columns in Query Editor.
2. Create the relationship of the two tables like below.
3.Then you could create the Matrix visual like below.
Hope it can help you!
Best Regards,
Cherry
Resident RockstarHi killingaxe,
For your output, you could get it without creating a calculated column.
Actually ,the calculated column is not dynamic so you can't get the output when you filter on US.
You could try to follow the steps below to get your desired output.
1. You should create the relationship of the two table so you need to unpivot columns in Query Editor.
2. Create the relationship of the two tables like below.
3.Then you could create the Matrix visual like below.
Hope it can help you!
Best Regards,
Cherry