Database Reference
In-Depth Information
Figure 9-17.
Creating measures for stocks
Go ahead and add another measure for
stock_volume,
but this time make
Sum
the aggregation function. Once
the measures are created, click on
PivotTable
➤
PivotChart
as shown in Figure
9-18
. That will open a new worksheet
with a chart.
Figure 9-18.
Creating a PivotChart
Once the new worksheet with the data models is open, drag and drop
stock_symbol
to
Legend (Series)
. Then drag
HDate
to
Axis (Category)
and
Average of Stock Price Close
to
Values
as shown Figure
9-19
.
