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 100% Stacked 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
23.
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 columns or groups of columns on the X-axis. Multiple groups
are nested, as we shall see within our current practice example.
24.
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.
25.
Type (or cut
and paste) the following into the Name box, atop the General tab:
chart1_Cat1_Year
26.
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.
27.
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 Calendar
Years will sort in numerical order), we will accept our input at this stage.
The Grouping
and Sorting Properties dialog (General tab) appears, with our modifications, as
shown in Illustration 27.
Illustration 27: The Grouping and Sorting Properties Dialog with Our Modifications
28.
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. Next we will add
another Category group to our report.
29.
Click the Add...
button to the right of the Category groups list box, just as we did before.
The Grouping
and Sorting Properties dialog appears, once again, defaulted to the General
tab.
30.
Type the
following into the Name box, atop the General tab:
chart1_Cat2_Territory
31.
Click the top
row of the Expression box within the Group on section, once again, to enable the
selector button (the downward-pointing arrow) on the right side of the box.
32.
Select =Fields!Sales_Territory_Group.Value
from the options that appear, as depicted in Illustration 28.
Illustration 28: Select =Fields!Sales_Territory_Group.Value in the Top Row of the Expression List ...
The Grouping
and Sorting Properties dialog appears, with our modifications, as shown in Illustration
29.
Illustration 29: The Grouping and Sorting Properties Dialog with Our Modifications
As we
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 Territory Groups will sort in natural,
alphabetical order), we will accept our input at this stage, just as we did
with the previously added Category group, chart1_Cat1_Year.
33.
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, once again. Our next step will be to add another group this time a Series
group. A 100% Stacked Column chart displays all series, stacked into a single
column for each respective category to which they relate. The height of each column
is determined by the total of all series values for the category involved. 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.
34.
Click the Add...
button to the right of the Series groups list box, much 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.
35.
Type (or cut
and paste) the following into the Name box, atop the General tab:
chart1_Series1_Reason
36.
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.
37.
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, too,
will sort in natural, alphabetical order), we will accept our input at this
stage, just as we did with the previously added Category groups, chart1_Cat1_Year
and chart1_Cat2_Territory.
38.
Click the OK
button at the bottom of the Grouping and Sorting Properties dialog, to save our
settings and to dismiss the dialog.
39.
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.