Database Reference
In-Depth Information
Create another new calculated member, and use the following formula:
CASE WHEN [Measures].[MetricValueAvg] = NULL THEN NULL ELSE
MAX(
{([DimCountry].[Regions].CurrentMember.Parent).Children}
,[Measures].[MetricValueMax]
)
END
Your screen should look like the one in Figure 12-42.
F I g u R e 12 - 42
Calculated column
You now have two target values to use for the bullet graph. Click OK twice
and then remove the footer and the title on the report.
In the Insert tab, click Matrix
a
Matrix Wizard. Choose the dsOECD dataset
you just created. Add Country Name to the Row group, and MetricValueAvg to
the values, and click Next. Uncheck Show Subtotals and Grand Totals on the
next screen and click Next. Finally, choose the generic style and click Finish.
On the table that appears, right-click the Metric value column, and choose
Insert Columns
a
Right. Click the new cell that appears, parallel to the Country
Name, and from the Ribbon choose Insert
a
Gauge. Click the cell again to
make the gauge choice screen in Figure 12-43 appear, choose the linear bar,
and then click OK.
