Database Reference
In-Depth Information
=switch(
Parameters!Measure.Value = "ReserveValue",
Fields!ReserveValue.Value
,Parameters!Measure.Value = "MetricValueAvg",
Fields!MetricValueAvg.Value
,Parameters!Measure.Value = "MetricValueMax",
Fields!MetricValueMax.Value
,Parameters!Measure.Value = "ReserveValue",
Fields!MetricValue.Value
)
This piece of code sets the value of the Measure field to the value of the field
chosen by the user. Next, we will do the same for the X-Axis and Y-Axis fields.
Create two new calculated fields called XAxis and YAxis. The code for the
X-Axis is shown in the following snippet:
=switch(
Parameters!XAxis.Value = "Year", Fields!YearName.Value
,Parameters!XAxis.Value = "Month", Fields!MonthName.Value
,Parameters!XAxis.Value = "Date", Fields!Date.Value
,Parameters!XAxis.Value = "Subject", Fields!Subject.Value
,Parameters!XAxis.Value = "Category", Fields!Category.Value
,Parameters!XAxis.Value = "Area", Fields!Area.Value
,Parameters!XAxis.Value = "Metric", Fields!Metric.Value
,Parameters!XAxis.Value = "GeoRegion", Fields!GEO_Region.Value
,Parameters!XAxis.Value = "GeoSubregion",
Fields!GEO_Subregion.Value
,Parameters!XAxis.Value = "CountryName",
Fields!CountryName.Value
)
The code for the YAxis is very similar, as you can see:
=switch(
Parameters!YAxis.Value = "Year", Fields!YearName.Value
,Parameters!YAxis.Value = "Month", Fields!MonthName.Value
,Parameters!YAxis.Value = "Date", Fields!Date.Value
,Parameters!YAxis.Value = "Subject", Fields!Subject.Value
,Parameters!YAxis.Value = "Category", Fields!Category.Value
,Parameters!YAxis.Value = "Area", Fields!Area.Value
,Parameters!YAxis.Value = "Metric", Fields!Metric.Value Value
,Parameters!YAxis.Value = "GeoRegion",Fields!GEO_Region.Value
,Parameters!YAxis.Value = "GeoSubregion",
Fields!GEO_Subregion.Value
,Parameters!YAxis.Value = "CountryName",
Fields!CountryName.Value
)
Now finish by adding a new column chart, using the fields as shown in
Figure 13-20.
