Microsoft Office Tutorials and References
In Depth Information
FIguRE 4-11 PowerPivot detects the need for missing relationships.
She makes PowerPivot detect the necessary relationships, and then because she needs to
aggregate the LineTotal by year and month, not by date, she follows the procedure already
shown in Chapter 2 to create aggregator columns in the SalesOrderHeader table, which
contains the year and the month of the order date. She ends up with the report shown in
FIguRE 4-12 The final sales report produced with PowerPivot.