Microsoft Office Tutorials and References
In Depth Information
Working with SQL Server Analysis Services
Scroll down and check Customer Geography to place it on the PivotTable rows.
Scroll down, right-click Product Categories, and select Add to Column Labels to place them on
Scroll back up to the Date dimension and expand the Calendar folder.
Right-click Date.Calendar and select Add to Report Filter to place it on the report filter.
In the PivotTable Options tab on the Ribbon, change the PivotTable Name to Internet Sales .
Select the All Periods cell for the PivotTable Report Filter value.
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.