How to create columns based on values

[amruta_j]

Hi, Below is my requirement :

I want three columns based on values.

1. If Actual > Target, It should appear in the first column Green.

2. If (Target - Actual) > 5, It should come under 2nd one Amber.

3. If Actual <  Target, It should come in 3rd one Red.

How can I get this?

Thank You!

[sunny_talwar]

Are you comparing row level values or are you comparing Aggregated values (Sum(Actual) and Sum(Target))? Also, do you need this in the script or front end?