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...
Hi Shishir22 ,
Unfortunately, I am able to add measures only as a row in matrix but the requirement is to add current, prior week, MoM, YoY, WoW measures in columns .
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