How to add colours ?

[ramcena306]

The below table shows product sales .

Header 1	Header 2
Product	Sales
Car	100
Fridge	50
Television	200
WashingMachine	70

How can i achieve this ?

sales > 150 is to be shown in Green

sales < 80 is to be shown in Red  ???

[cristinapo]

Hi Ramesh

In your chart use  Properties>Visual Cues like below

[Anil_Babu_Samineni]

You can use BG color like

If(Sum(Sales) > 150, Green(), If(Sum(Sales) < 80, Red()))

[devarasu07]

Hi,

if( sum(Sales)>150,Green(),  if(sum(Sales)<80,Red()))

[ramcena306]

Thank You devarasu07 R