Forum Discussion
Show category in Matrix table
Hello professionals, I have created a matrix table as below but I need to show like this so I need to to get a category lable for...
Hi jaipal
I think the result you want in your screenshot is to get hierachy level in Column Field in Matrix. However [Revenue], [Margin] and [%] are all measure/column names in Value field in Matrix. We couldn't create hierachy level in matrix by column headers. You need to transform your table like unpivot to get two column [Level1] and [Level2].
They looks like as below.
Level1 Level2
JOB to Date Revenue
JOB to Date Margin
JOB to Date %
...
Add them in Column in Matrix and get the hierachy level you want.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.