The KPI object can also be represented using two measures. We can show a comparison between key figures in a single KPI object. For example, the absolute sales and target values can be shown adjacent to each other as separate figures. If the sales are greater than the target, then the value is represented in green, or else in red. This can be achieved by following these steps:

1. Create a new KPI object by following the steps given in the previous recipe. Label the object Sales vs Target-1.
2. Add the following measures:
   • • Sum(Sales): Label it Sales
     • Sum(Target
   • ): Label it Target
3. For Sales, switch on the Conditional colors.
4. Click on Add limit.
5. Set the limit under the function as:

=Sum(Target)

6. Set the first color as red with the  symbol and the second as green with the  symbol.
7. For Target, set the font color as Blue.
8. The resultant object will be similar to the following: