Database Reference
In-Depth Information
FIguR e 10 - 9
Setting KPI values in Excel
When you're done, create a new pivot table. Add the Sum of Value and Status
measures to the pivot table, and drag the country column of the DimCountry
table from the list of fields to the rows. You need to add a filter and choose a
single metric to get a meaningful number. See Figure 10-10 for an example.
FIguR e 10 -10
A pivot table with indicators
