Databases Reference
In-Depth Information
10. In the Design the Table page you will see the three fields you selec-
ted in the MDX query builder. In this report you will group the sales of
customers based on the provinces. Therefore, select the
State_Province_Field and click on the Group button to move the field
to the Group pane. Select the fields Customer Gender and
Fact_Internet_Sales__Sales_Amount fields and click on the Details
button to move the fields to the Details pane as shown in
Figure
17-16
.
Figure 17-16
11. Similar to the relational report you created earlier, select Stepped
layout in the next page. Select the option to have subtotals displayed
as well as enable drilldown in this page as shown in
Figure 17-17
and click the Finish button. In the Final page of the wizard, name the
report AnalysisServicesSalesReport and click the Finish button.
Search WWH ::
Custom Search