Microsoft Office Tutorials and References
In Depth Information
FIguRE 7-26 The definition of DailySales measure.
The final result is shown in Figure 7-27, where both WorkingDays and DailySales measures are
exposed in the PivotTable. However, in a real report, you usually do not show the working days
number but just the average measures, such as Daily Sales.
FIguRE 7-27 PivotTable showing results for WorkingDays and DailySales.