Forum Discussion
How to sort a matrix when multiple columns exist without SSAS
I do have multiple columns on a matrix but I can sort only based on the total. How can I sort based on another column? See picture for details.
I found a workaroun but still quite complex to explain
- Duplicate the sales query
- Filter the current year
- Select distinct customer names and creating a new column summarizing sales
- Set the new column as the sorting column
- Create a relationship between the customer in the original table and the new table created
- Add in the row of the matrix the customer from the new table
- Sort based on customer name
2 Replies
I found a workaroun but still quite complex to explain
- Duplicate the sales query
- Filter the current year
- Select distinct customer names and creating a new column summarizing sales
- Set the new column as the sorting column
- Create a relationship between the customer in the original table and the new table created
- Add in the row of the matrix the customer from the new table
- Sort based on customer name