Forum Discussion
Solved
Multiple date columns when values are shown on rows
I'm trying to mimic this table: Column 1: 2018 current month Column 2: 2019 current month Column 3: 2018 YTD (in 2018) Column 4: 2019 YTD So far I have this: I've enabled '...
HI dodgun ,
The simplest way is enter to query editor and do unpivot columns feature on date fields which you mentioned.
Then you can use original row field, unpivoted attribute fields and value field to create a matrix visual.
Regards,
Xiaoxin Sheng
HI dodgun ,
The simplest way is enter to query editor and do unpivot columns feature on date fields which you mentioned.
Then you can use original row field, unpivoted attribute fields and value field to create a matrix visual.
Regards,
Xiaoxin Sheng