I could suggest the variant with percentile(). You could color your values according to the value of percentile 30 and 70. But, in some way, it depends from rank. Also you will get a bit different amount of colored values, because it calculates a value that between n and n+1 values. Where n is calculated by formula:
n=[(P/100)*(N-1)+1]
where
P - percentile (for example, 30%),
N - number of all values.
For your example n = [(30/100)*(12-1)+1]=[4.3]=4.
That means, that 4 values would be under percentile value. And for your data percentile 30% would be 4.922. The similar situation would be for percentile 70.
Hello Angelina,
Thanks a lot for quick response. I could create report using Rank/All/Percentage functions.
