reg-visual cubes

[#1]

HI Team,

1. i have 500 records in my table and i want to get if 1-50 records should get yellow color,50-100=orange,100-150=blue  for this we can write condition or normally we can do like if records>50 yellow

can anyone say

.

[tresesco]

If it's a straight table, try expression like: If(RowNo(Total)>50, yellow(), ....)

[#3]

thanx

[#4]

and can u say one thing if i have 100 records and i want to display top 5 records and low 5 records

[cfz]

Hi,

You can write an expression  for doing this in the background color under the dimension like in the attached example .

I hope it helps

Carlos

[tresesco]

reg-var

[preminqlik]

sum({{<Dimension={'=rank(sum(sales))<6'}>}sales)   top 5

sum({{<Dimension={'=rank(-sum(sales))<6'}>}sales)   bottom 5