Color Expression

[Joaquin_Lazaro]

Hello:

I've this color expression = IF (Sum(Visits) > 200000, Blue(), Green()) and it works fine.

Now I need to change it by another one thar prints in blue the top five values and in green other values which conpletes the list.

Thank you

[#2 · Accepted solution]

Hi,

use something like this

= if(Rank(Total Sum(Visits))<=5,Blue(),Green())

[Joaquin_Lazaro]

Thank you Vivek.

This is the solution