Database Reference
In-Depth Information
This dialog box allows you to individually select the members that you would want to
exclude from the previous set expression.
26.
In the
Av a i l a b l e M e m b e r s
pane of the dialog box, expand the
Sales and Marketing
(analysis)
and
Sales
folders.
27.
Expand the
Promotions
hierarchy.
28.
Drag the
Regular sale
member into the
Members
pane.
29.
Click
OK
to close the dialog box.
The Set Definition dialog box should look like Figure 6.42.
Figure 6.42
Completed exclude set definition
30.
Click
OK
to close the Set Definition dialog box and return to the work area.
Step 3: Create the Descriptive Statistics
With most of the query built, we will look at the analysis of the gross profit for orders grouped by
the different campaigns.
1.
In the
Explorer Bar
, mouse over the
Page Explorer
tab and select the
Report Pages
folder.
2.
In the
Report Pages
pane of the work area, click
Page1
to select it.
3.
In the
Properties
pane, change the
Name
property to
Descriptive Statistics
.
4.
In the work area, double-click the
Descriptive Statistics
page to open it.
