Databases Reference
In-Depth Information
We will now create a bar chart to visualize the comparison of the two record sets:
1.
Before continuing, copy the listboxes corresponding to
Year
,
Quarter
,
and
Month
from one of the other sheets and place them into the new
Comparative Analysis
sheet as linked objects.
2.
Now, create a new chart by clicking on the
Create Chart
button from the
Design
toolbar and setting the following properties:
°
Chart Type
:
Bar Chart
°
Window Title
:
Group A vs Group B
°
Show Title in Chart
: Disabled
°
Dimension
:
Period
°
Expression 1
:
Label
:
Group A
Definition:
Sum({[Group A] * $} [# Departures Performed])
°
Expression 2
:
Label
:
Group B
Definition:
Sum({[Group B] * $} [# Departures Performed])
°
Primary Dimension Labels
: With diagonal orientation
°
Number Format Settings
:
Integer
for both expressions
At this point, our chart will respond to user selections on either state and show
the corresponding comparisons. Let's select the following values in each of the
alternate states:
• Group A:
°
Flight Type
:
International, US Carriers Only
°
Destination City
:
Chicago, IL
• Group B:
°
Flight Type
:
Domestic, US Carriers Only
°
Origin City
:
Chicago, IL
°
Destination State Code
:
CA
•
Year
:
2011
The selection in
Year
is made in the default document state, as the
corresponding listbox has not been associated to either alternate state.
This selection will apply to both chart calculations.