Forum Discussion
Sorting a matrix visual by 2 columns/measures - creating a rank with 2 measures
I have a matrix visual in a client reporting, where I am showing the revenue by client and across the countries where the client had spent.
I would like to sort this, so that the client which has spent in many countries is at the top, decsending by total spend value.
I have a created a measure which provides me with the info in how many countries the client had spend and I also have the total revenue.
However, I had not been able to create a ranking measure, which combines these 2 info and sorts the info accordingly.
Here is screen shot of my matrix visual - the client 577 should be listed at the top, followed by the client 263 and then client 447.
I have a test file created, but I cannot see the upload icon to attach it to the post ??
Any support the community can provide, is greatly appreciated.
Thanks, Manfred
I have now found a way to accomplish this, by using the new RANK function, where I can do a orderby on 2 measures/field. This worked out very well and I have ended up with exactly what I had been looking for.
Thanks
3 Replies
- Manne_DEFrequent Visitor
I have now found a way to accomplish this, by using the new RANK function, where I can do a orderby on 2 measures/field. This worked out very well and I have ended up with exactly what I had been looking for.
Thanks
- vanessafvg
Community Champion
you need to use your own cloud storage and provide the link.
- MageVortex
Helper I
I would probably create a measure that does some sort of multiplicative sum to determine the way I want it ordered, then sort by that measure, but that would probably not work how I wanted in quite a few different instances, so I'm interested in seeing a superior method of resolving this.