Query for a data set

Let us specify the query data set.

  1. Select the Sales.Turnovers virtual table as the data source.
  2. Select the following fields from this table (fig. 13.100):
    • SalesTurnovers.Customer
    • SalesTurnovers.RevenueTurnover
    • SalesTurnovers.CostTurnover

    Fig. 13.100. Fields selected for the query
  3. Click the Unions/Aliases tab.
  4. Change RevenueTurnover to Revenue and change CostTurnover to Cost.
  5. Click OK.

    This completes the query creation. Since the query contains only expressions that you already know, we will not explain it in detail. Let us proceed to editing the data composition schema.
Next page: Calculated fields
Be the first to know tips & tricks on business application development!

A confirmation e-mail has been sent to the e-mail address you provided .

Click the link in the e-mail to confirm and activate the subscription.