List Column values display like 'excellent' and 'poor'

[Revathi_M]

I have one List in  column values display 1 to 100
here i need less 30 I need Display Label as"Poor"
30 to 70 "very Good"
more than 70 display "excelent"

I am traied "conditional style" it display only color not label like "good" "poor" "excellent"


I am need same column or new column


2nd question : how to add new column in list

thanks

[BigChris]

Hi Revathi_M,

In your report drag in a new Query Calculation and give it a name. For your calculation you then want something like

Code Select Expand


Case
  When [Date Item] between 0 and 29 then 'Poor'
  When [Data Item] between 30 and 70 then 'Very Good'
  When [Data Item] between 71 and 100 then 'Excellent'
Else 'Out of Range'
END
You can then apply you conditional format to your new field.