KPI Field for Displaying KPI Icon in PivotTable

Which KPI field should you add to a PivotTable if you want to display the KPI icon?

A. Status

B. Goal

C. Value

D. Measure

Answer:

The KPI field that should be added to a PivotTable to display the KPI icon is the Measure field.

Here, correct answer will be D. Measure.

The Measure field is crucial in displaying the KPI icon in a PivotTable. This field contains the data that is used to determine the KPI icon and can be configured to show the icon based on certain criteria.

In addition to the Measure field, other fields that play a role in KPI representation are Status, Goal, and Value. The Status field provides information on whether the KPI is meeting or exceeding its goal, the Goal field contains the target value for the KPI, and the Value field holds the actual value of the KPI.

By including the Measure field in the PivotTable, users can easily visualize the performance of the KPI using the KPI icon. This visual representation helps in quickly assessing the status of the KPI and its proximity to the set goal.

Understanding the significance of each field in a PivotTable is essential for effectively analyzing KPI data and drawing actionable insights from it. By utilizing the appropriate fields, users can make informed decisions and track the progress of key performance indicators with ease.