Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
I made a matrix in which the column y is divided by proceeds and total costs. So, the distinction is made by the matrix. Now I think it is sorting on the alphabet. However, I'd like to show first total costs and then proceeds. I don't know how to sort this because these values are actually one column in the data.
Thank you in advance.
Regards,
Tom
Solved! Go to Solution.
Hi @Bipin-Lala
Thank you for your answer.
I eventually solved it on a different way:
I made a conditional column, with total costs = 1, proceeds = 2 (called it ranks).
Then I made this ranks column a number type.
Then I sorted the table on the basis of the ranks column. This causes that the initally column also got sorted in the right way.
When I tried again in the matrix, I got the sequence I wanted.
Regards,
Tom
Hi @Bipin-Lala
Thank you for your answer.
I eventually solved it on a different way:
I made a conditional column, with total costs = 1, proceeds = 2 (called it ranks).
Then I made this ranks column a number type.
Then I sorted the table on the basis of the ranks column. This causes that the initally column also got sorted in the right way.
When I tried again in the matrix, I got the sequence I wanted.
Regards,
Tom
User | Count |
---|---|
100 | |
87 | |
81 | |
76 | |
71 |
User | Count |
---|---|
113 | |
104 | |
100 | |
73 | |
65 |