Let us look at the following steps and begin our exercise:
- In the workbook associated with this chapter, navigate to the Row_Agg_Tbl worksheet.
- Select Analysis > Create Calculated Field to create the following calculated fields. Note that each must be created separately, that is, it isn't possible in this context to create a single calculated field that contains all three calculations:
Name |
Calculation |
Lev – Row |
[Number of Records]/[Quantity] |
Lev – Agg |
SUM ([Number of Records])/SUM (Quantity) |
Lev – Tab |
WINDOW_AVG ([Lev - Agg]) |
- In the Data pane, right-click on the three calculated fields you just created and select Default Properties | Number format.
- In the resulting ...