Forum Discussion
Anonymous
7 years agoNot applicable
Dynamicaly named columns
Hi. Is there any way how to dynamicaly name column in table or matrix visualisation? I have simple table - revenue per month: Month - 2019 - 2018 - 2017 January - 100 - 80 - 60 February - 120 - ...
parry2k
7 years agoSuper User
Anonymous you just unpivot your data, in advanced editor, select month, right click and then choose unpivot other columns
You will get two new colums, attribute and value and rename attribute to year. Apply the changes.
Now add matrix visual, put month column on rows, year column on columns and value column on value, and you will have the result.