Forum Discussion
Clustered columns with unpivot input table
I have an input data with this structure: Region Country City Year Month Metric Value EMEA France Paris 2021 1 Sales 1000 EMEA France Paris 2021 2 Sales 900 EMEA Fr...
The idea is a table like below. So the year columns have to be side by side (instead of first 2020 columns and then 2021).
I can easily get this chart if I pivot the original table, but I have many other columns and will use the input data for other tables and charts in the same dashboard.