Forum Discussion
formatting and customizing Matrix rows and Column
I created a matrix but I don't want my matrix sort by decsending or ascending how can I customiz that in my order. Also same thing for the rows. for example I want to have UCS, CSE, Net Rev...
I have created the new column in my SQL table based on what I want to be sort by, but still doesn't give me an option based on that.
You are going to have to be more specific shahinnakhai.
I just did a direct query connection to my SQL server and sorted based on another column. The granularity of the sort by column has to be 1:1 with the column sorted. So, if you want to sort by a month name by month, the sort by column must be 1-12 (or have 12 unique values). It cannot be a date column.
If your column you want to sort has 15 unique values, your sort by column must have 15 unique values to sort on.