I need some help with being able to highlight those values which are greater than average of top 5 values.
In this case, top five values are: 8,7,6,5,5. and average of these values would be 6.2. So all the values in the table >6.2 need to be highlighted in a colour say blue.
I have tried using:
if(Values > if(rank(Values)<=5, sum(Values))/5, LightBlue(),LightGray()) in the 'Background Colour' option of the Values expression but it doesn't seem to work. Can this be done in the front end using the table options itself?