21.
Click the Data
Output tab of the Edit Chart Value dialog.
The Data
Output tab affords us a means of defining XML data output options
for the values in the chart. We will not leverage these capabilities within
this introduction to simple Column charts, and will therefore leave the
settings of the Data Output tab at their defaults, as shown in Illustration
25.
Illustration 25: The Data Output Tab with Default Settings
22.
Click the
OK button at the bottom of the Edit Chart Value dialog, to dismiss
the dialog with our settings.
We are
returned to the Data tab of the Chart Properties dialog. Next we
will work with the Category groups area of the tab, just under the Values
area. Categories are displayed as individual slices in the
pie. Each Category is displayed in the chart legend, when the legend
is selected for use.
23.
Click the Add...
button to the right of the Category groups list box, found
immediately underneath the Values list box with which we worked above.
The Grouping
and Sorting Properties dialog appears, defaulted to the General tab.
24.
Type (or cut
and paste) the following into the Name box, atop the General tab:
Year
25.
Click the top
row of the Expression box within the Group on section that
appears just underneath the Name box, to enable the selector button (the
downward-pointing arrow) on the right side of the box.
26.
Select =Fields!Calendar_Year.Value
from the options that appear, as depicted in Illustration 26.
Illustration 26: Select =Fields!Calendar_Year.Value in the Top Row of the Expression List ...
As we
have no input for the Filters or Data Output tabs (which resemble
their counterparts in other areas of the Report Designer, as we have,
and shall, see), within the context of this newly added group, and as we intend
to leave the Sorting at the settings naturally found within the cube
structure (the Sales Reasons will sort, where appropriate, in alphabetical
order), we will accept our input at this stage.
The Grouping
and Sorting Properties dialog appears, with our modifications, as shown in Illustration
27.
Illustration 27: The Grouping and Sorting Properties Dialog with Our Modifications
27.
Click the
OK button at the bottom of the Grouping and Sorting Properties
dialog, to save our settings and to dismiss the dialog.
We will
next add another Category group – this time a “group within a group,”
for the Sales Territory.
28.
Click the Add...
button to the right of the Category groups list box, once again.
The Grouping
and Sorting Properties dialog appears, defaulted to the General tab,
as before.
29.
Type (or cut
and paste) the following into the Name box, atop the General tab:
Territory
30.
Click the top
row of the Expression box within the Group on section that
appears just underneath the Name box, again to enable the selector
button (the downward-pointing arrow) on the right side of the box.
31.
Select =Fields!Sales_Territory_Group.Value
from the options that appear.
Because,
once again, we have no input for the Filters or Data Output tabs,
within the context of this newly added group, and as we also intend, as
earlier, to leave the Sorting at the settings naturally found within the
cube structure (the Sales Reasons will sort, where appropriate, in
alphabetical order), we will accept our input at this stage.
The Grouping
and Sorting Properties dialog appears, with our modifications, as depicted
in Illustration 28.
Illustration 28: The Grouping and Sorting Properties Dialog with Our Modifications
32.
Click the
OK button at the bottom of the Grouping and Sorting Properties
dialog, to save our settings and to dismiss the dialog.
We are
returned to the Data tab of the Chart Properties dialog, which
appears, with our Values and Category groups settings, as shown
in Illustration 29.
Illustration 29: Chart Properties Dialog Box – Data Tab with Our Settings
Our next
step will be to add another group – this time a Series group. Series
are displayed as individual slices in the Pie chart. Each series
is also displayed in the chart legend. At this point, we will add a Series
group to contain the Sales Reason (“Manufacturer,” “On Promotion,” “Price,”
etc.) that is associated with the grouped Internet Sales totals that the
report will present.
33.
Click the Add...
button to the right of the Series groups list box, just as we did
in making our two Category groups entries earlier.
The Grouping
and Sorting Properties dialog appears, once again, defaulted to the General
tab.
34.
Type (or cut
and paste) the following into the Name box, atop the General tab:
Sales_Reason
35.
Click the top
row of the Expression box within the Group on section, yet again,
to enable the selector button (the downward-pointing arrow) on the right side
of the box.
36.
Select =Fields!Sales_Reason.Value
from the options that appear, as depicted in Illustration 30.
Illustration 30: Select =Fields!Sales_Reason.Value in the Top Row of the Expression List ...
The Grouping
and Sorting Properties dialog appears, with our modifications, as shown in Illustration
31.
Illustration 31: The Grouping and Sorting Properties Dialog with Our Modifications
Because
we again have no input for the Filters or Data Output tabs within
the context of this newly added group, and as we intend to leave the Sorting
at the settings naturally found within the cube structure (the Sales Reasons
will sort in alphabetical order), we will accept our input at this stage, just
as we did with the previously added Category groups, Year and Territory.
37.
Click the
OK button at the bottom of the Grouping and Sorting Properties
dialog, to save our settings and to dismiss the dialog.
We return
to the Data tab, once again, which appears, with our Values, Category
groups, and Series groups settings, as depicted in Illustration 32.
Illustration 32: Chart Properties Dialog Box – Data Tab with Our Settings
We will
move to the X Axis tab in the subsection that follows.
» 
Comment and Contribute
