1. Go to the App overview and create a new sheet.
2. Name the sheet KPI and open it.
3. Go to Edit mode by clicking on .
4. Drag the  object from the assets panel onto the sheet.
5. Next, add the following measure:

(Sum(Sales)-Sum(Target))/Sum(Target)

6. Name the label Sales vs Target.
7. Once we add the measure, we can see a host of properties, such as number format, color, and so on, for the measure directly beneath the Expression editor box.

8. For the measure, change the Number formatting to Number and select the percentage format (12.3%) from the available formats under the dropdown.
9. Next, add the limits to define colors. Switch on Conditional colors.
10. Click on Add limit and set the limit under the function to 0.
11. Click on the first segment of the color bar and set the color as red with the symbol. Click on the second segment of the color bar and set the color as green with the  symbol.
12. The KPI object appears as follows:

13. Under Appearance, click on General, switch on Show titles, and add the title Sales vs Target.
14. Add the subtitle as follows:

IF(getselectedcount(Country)>0,Country,' ')

15. Next, go to the Presentation dropdown and uncheck Show title.
16. Add the Filter pane object from the assets panel on the sheet and select the dimension as Country. Select different countries to see how your organization is faring with respect to each country:

17. Next, we will link our KPI object to a sheet that shows detailed reports.
18. Create a new sheet called Reports.

19. Create a Table report on the reports sheet with Country as the dimension and the following measures:
    • Sum(Sales): Label it Sales.
    • Sum(Target): Label it Target.
    • (Sum(Sales)-Sum(Target))/Sum(Target): Label it Sales vs Target. For the measure, change the Number formatting to Number and select the percentage format (12.3%) from the available formats under the dropdown.
20. Move back to the KPI sheet and enter Edit mode by clicking on .
21. Select the KPI object. This will activate the Properties panel on the right.
22. Under Appearance, go to Presentation and switch on Link to sheet. Under Select a sheet, select the Reports sheet and click on .
23. When we click on the KPI object in the user interface, it directs us to the reports sheet where you can analyze all the sales and target figures for each country: