Forum Discussion
Solved
Showing YearWeek as Week in matrix column
I have a matrix which shows week code in the columns. This is in this format: 202106 202107 202108 Due to space constraints I want to truncate the year and show it like this: 06...
NickMcDermaid , I think the first one should work.
Take both Year and Week on Column. And use reverse square Y sign( for columns, if needed) and expand it, and save
Thanks! It worked! I was a little puzzled by your comment but let me explain it in detail for anyone else.
It turns out you can nest things in columns.
1. Nest "Year" above "Week" in columns
2. You only see Year in the columns
3. Press the "expand all down one level in the hierarchy" button (yes it look like an upside down square Y with arrows on it)