Figure 6-35 The chart type can be changed by right-clicking on an empty part of the
chart and choosing Chart Type on the menu.
180 B u s i n e s s I n t e l l i g e n c e w i t h M i c r o s o f t O f f i c e P e r f o r m a n c e P o i n t S e r v e r 2 0 0 7
Figure 6-37 shows two measures that have been added to the rows: Gross Profit
and Gross Profit Margin. The four years of the time dimension are on the columns.
Finally, a single product category, Mountain Bikes, is placed in the background. The
user right-clicks on a blank area of the chart and this time chooses Series Properties.
The Series Properties dialog box allows the user to select the Gross Profit Margin
series, change it to a line chart, and then select the right axis. As can be seen in
Figure 6-37, the Series Properties dialog shows these selections, but the chart in the
background already shows the results. The left axis ranges from zero to 2.6 million,
which represents the gross profit for mountain bikes. The right axis ranges from zero
to 26% which covers the range for the gross profit margin. This chart easily shows
two very different measures in a way that makes sense.
Working with the Grid
The ProClarity grid has already been shown because it is part of three of the four
basic views. The grid is powerful and allows for both drilling down and expanding
dimensions on either the rows or columns. In addition, the grid supports font and
color changes, subtotals, exception highlighting, and more.
Pages:
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243