Both are relatively large numbers,
with Sales Amount showing approximately $110 million and a Gross Profit of
approximately $12.5 million. Gross Profit Margin, on the other hand, is a very small
number, having a value of just .1143 (11.43%). Because this chart is comparing
large numbers to a percentage, it automatically moves the Gross Profit Margin to the
right-hand Y-axis and makes its series type a line, while the other two measures are
represented by bars. In this case, because the X-axis has only a single value, the line
appears as a single point. Note that rearranging the measures to put the percentage
first will show the entire point, as it will place the point in front of the bar.
Viewing this particular chart in the Browse window and drilling down on the
Product Model Lines hierarchy allows the users to see the Gross Profit Margin line
that appeared as a single point before. Figure 6-16 shows what this looks like.
*Note that the Gross Profit Margin is automatically moved to the right-hand Y-axis but only a single point shows
up because the X-axis is set to a single member (the All member).
Figure 6-15 A report with multiple measures on the series
156 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
Note that in this case, the X-axis contains the Product Model Lines hierarchy,
whereas many time users would expect to see Time across the bottom, especially in
cases where they are examining sales figures.
Pages:
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217