Database Reference
In-Depth Information
Microsoft Excel is now connecting to the data source and retrieving the data from the
view created earlier in this recipe. You can now use common Excel features to analyze
your data, such as the following:
1. In the
PivotTable Fields
pane, drag and drop the
Managed Entity Type
,
Per-
formance Object, Performance Counter
,
Year
, and
Month
fields to the
Filters
area.
2. In the
PivotTable Fields
pane, drag and drop the
Day
field to the
AXIS
(CATEGORIES)
area.
3. In the
PivotTable Fields
pane, drag and drop the
AVG
field to the
Values
area.
4. Right-click on the chart. Select
Change Chart Type…
and then
Line
. Click on
OK
.
5. Set filters by clicking on the arrow next to the
Filter
field in the chart. Select
Select Multiple items
. Uncheck
(All)
and select the fields you want to use as a
filter, as shown in the following screenshot: