Databases Reference
In-Depth Information
plus (+) sign between these measures as shown in
Figure 17-19
.
Click OK to create the calculated measure.
Figure 17-19
3. Create a calculated measure called Total Product Cost as the sum of
the product costs of the Products sold via Internet and Reseller.
4. Create a calculated measure called Total Profit, which is the differen-
ce between the numerical values in the calculated measures Total
Sales Amount and Total Product Cost. You will now see the three
calculated measures in the calculated members' pane of the query
builder as shown in
Figure 17-20
.
Search WWH ::
Custom Search