Database Reference
In-Depth Information
Figure 9-16.
Creating the hierarchy
Next, go back to the
Data View
and create measures for your stock table. Select
stock_price_open,
stock_price_high, stock_price_low, stock_price_close
, and choose
Average
under
AutoSum.
Doing that will create
measures with average calculations as shown in Figure
9-17
.