Let us specify the query data set.
- Select the Sales.Turnovers virtual table as the data source.
- Select the following fields from this table (fig. 13.100):
- SalesTurnovers.Customer
- SalesTurnovers.RevenueTurnover
- SalesTurnovers.CostTurnover
Fig. 13.100. Fields selected for the query - Click the Unions/Aliases tab.
- Change RevenueTurnover to Revenue and change CostTurnover to Cost.
- 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.