Forum Discussion
Helper IIIDynamic Rank Analysis Top 5 based on different measures
Since field value is dynamic and it changes by selection, you would not be able to sort for all. Let's say, you sort this by Unit Sold, it will sort but when change to other metric measure say revenue, sorting will change.
So to fix it, you need to use a column which is fixed. In this case Dynamic Rank could be used. See image below:If you don't want to show DynamicRank, you can do a little trick and formating. See image where is actually DynamicRank measure present but you would not be able to see it.
This way I acheived sorting as well as maintained visual requirement.
To acheive this, just change name in the value section of DynamicRank by double clicking to single space. change font color to white. Re adjust column width.
Hope this helps!!If this solved your problem, please accept it as a solution and a kudos!!
Best Regards,
Shahariar Hafiz
Helper IIIHi shafiz_p ,
I am just one step away from achieving the desired output, but there is a sorting issue. Metric values are not coming in proper order.
It would be great if you advise on this.
However, when I try to do it sorting but later is gets changed.
Thank you
Super UserSince field value is dynamic and it changes by selection, you would not be able to sort for all. Let's say, you sort this by Unit Sold, it will sort but when change to other metric measure say revenue, sorting will change.
So to fix it, you need to use a column which is fixed. In this case Dynamic Rank could be used. See image below:
If you don't want to show DynamicRank, you can do a little trick and formating. See image where is actually DynamicRank measure present but you would not be able to see it.
This way I acheived sorting as well as maintained visual requirement.
To acheive this, just change name in the value section of DynamicRank by double clicking to single space. change font color to white. Re adjust column width.
Hope this helps!!
If this solved your problem, please accept it as a solution and a kudos!!
Best Regards,
Shahariar Hafiz