I have some client churn information that I am attempting to place in a straight table chart. I need to sort them in order of contribution and then highlight the top three drivers (by shading all the others). I am successfully using the Rank function to achieve the shading.
This is looking good, but then I need to add an extra description column for the key insights and now the Rank function returns all 1s and the table sort stops working.
Can someone please explain how to fix this problem? I suspect I need to use the Aggr function to cater for the extra dimension, but I have not been able to find any information that explains this issue.