Forum Discussion

Shionfox's avatar
Shionfox
Regular Visitor
8 years ago

How to Set a KPI on a Calculated Table

Hi,

 

I got the following data:

 

 

 

 

(Column 4, And Column 5 are Calcualted Columns)

 

So, in order to sumarize it , I create a table as following 

 

  

 

 

I wanted to create a  table like the following, by now I don't know how to get this done....

 

 

My Final Goal is to get a table/report where  if  the value has met the target, then colour the raw on green else color a shape on green, else if the value  has not met the target, then colour the raw on red or else color a shape on red

 

 

Does anyone knows how to set it?