Need help with Matrix sorting on rows

[Anonymous]

Hi, Please see that I brought the "Sort" field in to Values in to order to sort but the issues is that anytime a new day's worth of data flows in, the column I brought for Sort shows up. Having issues Sorting within a Matrix. I have a field named "Sort". What it does is sorts By date the Category/SubCategory/Element so that they are continuously in the same order each time I get new records flowing in daily. I want it completely hidden. So maybe I'm going about this completely wrong. Is there a better way?

So as new dates flow into my matrix, I am forced to hide the sort column each time. I dont want to have to do this.

Thanks
Patrick
Developer

[Anonymous · Accepted solution]

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.

[lbendlin]

put the sort field into the tooltips area instead.

[Anonymous]

But not seeing a tooltip area under values for a Matrix

[lbendlin]

You are right, unfortuntely.  You may need to find a way to sort one column by another column.

Please provide sanitized sample data that fully covers your issue.

Please show the expected outcome based on the sample data you provided.