Microsoft Office Tutorials and References
In Depth Information
Working with SQL Server Analysis Services
7.
Scroll down and check Customer Geography to place it on the PivotTable rows.
8.
Scroll down, right-click Product Categories, and select Add to Column Labels to place them on
columns.
9.
Scroll back up to the Date dimension and expand the Calendar folder.
10.
Right-click Date.Calendar and select Add to Report Filter to place it on the report filter.
11.
In the PivotTable Options tab on the Ribbon, change the PivotTable Name to Internet Sales .
12.
Select the All Periods cell for the PivotTable Report Filter value.
13.
Use the Name Box on the formula bar to name the cell Date . (You use this as a workbook
parameter to filter the dashboard later.) Figure 12-22 shows the completed workbook.
Figure 12-22
Search JabSto ::




Custom Search