Need help with Matrix sorting on rows

Hi Anonymous ,

According to your screenshot, I know that you build matrix by format as below.

Category/SubCategory/Element  in Rows.

Date in Columns.

Value and Sort in Values.

I have created a sample to have a test and I can reproduce your problem. I think you are now trying to turn off word wrap function in Format and then reduce the width of the Sort column in matrix visual to 0 to hide Sort column in Value. However, you will load new data in current day to your report. Due to you add [Date] in matrix Column, Sort will appear in new date expanding columns. 

Here I suggest you to add Sort in to Rows. New matrix row field looks like Category/SubCategory/Element/Sort. Then turn off "Stepped layout" in Row headers and turn off the subtotal in Sort level. Then you can reduce the width of Sort to 0 and it won't appear again after you load new data.

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.