How to add colour in the report based on condition.

sri86
Tera Contributor

Dear Experts, 

I am using Multi Pivot Report, I have an requirement to display the value with different colour. For Example I have columns like Employee, Location, Manager, Month, Actual, Budget and Total. In report I am displaying Location wise, Manager wise, Employee wise , Manager wise Total value. I just need to highlight the total value with red and green colour. If Actual value is greater than budget value then in Red else in Green. 

Could any one suggest how we can do this, If not, what will be the best way to create this like attachment.

find_real_file.png

1 REPLY 1

Ct111
Tera Sage

Hi Please go through the below link

 

https://docs.servicenow.com/bundle/london-performance-analytics-and-reporting/page/use/reporting/concept/c_ChartColors.html

 

it will help you .

 

Mark my ANSWER as CORRECT and ANSWER if it helped