Databases Reference
In-Depth Information
Figure 6-27
3. For cost of goods sold, create a new calculated measure called
[Total Product Costs] using a method similar to the one described
in step 2 but with appropriate Product Cost measures from the
two measure groups.
4. Create a calculated measure called Profit. The MDX expression to
evaluate Profit is the difference of the calculated measures you
have created in steps 2 and 3. Enter the MDX expression [Meas-
ures].[Total Sales Amount] - [Measures].[Total Product Costs] in
the Expression text box as shown in Figure 6-28 .
Figure 6-28
 
 
Search WWH ::




Custom Search