Database Reference
In-Depth Information
6.
In the top center of the dialog box, click the
New Link
button.
An arrow defining the link between the two queries is displayed.
7.
Ensure that
Branch Region
is selected in both
Master
and
Detail
panes.
8.
Click the
New Link
button again.
It will seem as though nothing happened; however, there are two links now, one on top
of the other.
9.
Click on the
Ye a r
in the
Master
pane and on the
Ye a r
in the
Detail
pane.
Yo u r first Master Detail Relationships window should look similar to what's shown in
Figure 6.32.
Figure 6.32
First Master Detail Relationships dialog box
10.
Click
OK
to close the dialog box.
Now we will build the pie chart.
11.
From the
Data Items
tab, drag
Reason description
from the
Returns_by_Product_
Line
query into the
Series (pie slices)
drop zone of the pie chart.
12.
Drag
Return quantity
into the
Default measure
drop zone of the pie chart.