Forum Discussion
Adding multiple columns in matrix view
I need to create a matrix table like below. I have metrics 1,2,3 and Week field with all the weeks. How do I separate into the current, prior week etc and get MoM, YoY, WoW in the same matrix? Thi...
Hello pranesh246 ,
Can you please try dragging all the measure one by one in Values section of the matrix?
It should give you requried output.
Thanks!
Hi Shishir22 ,
It doesn't work because when I do that, measures are getting added on rows and not across the columns. I need to add measures across the columns which calculates value for respective rows.
| Current week | Prior week | Same week last month | Same week last year | Month on Month | Year on Year | Week on week | |
| Metric 1 | |||||||
| Metric 2 | |||||||
| Metric 3 |