Logical Data Warehouse Design - Data Warehouse Systems: Design and Implementation - page 159

Fig. 5.30 Definition of the dimensions of the Northwind cube
Fig. 5.31 Definition of the Net Amount derived measure
The derived measure Net Amount is defined as shown in Fig. 5.31 .Ascan
be seen in the figure, the measure will be a calculated member in the Measures
dimension. The defining expression is the difference between the Sales Amount
and the Freight measures.
Figure 5.32 shows an example of browsing the Northwind cube in Excel
using the PivotTable tools. In the figure, the customer hierarchy is displayed
on rows, the time hierarchy is displayed on columns, and the sales amount
measure is displayed on cells. Thus, the figure shows the yearly sales
of customers at different levels of the geography hierarchy, including the
individual sales of a shop located in San Francisco.