Filter Filter allows users to remove empty values from the series, the bottom axis, or both, as well as turn off
the filtering of empty values.
Pivot Pivot simply swaps the dimension in the Series with the dimension in the Bottom Axis. If more than one
dimension is found in either panel, it does not matter; all dimensions in the Series are swapped with all
dimensions in the Bottom Axis. The chart is redrawn accordingly.
Hide/Show
Information
The Hide or Show Information option will place a small information bar at the top of the graph or hide
it, depending on the current state. Note that in Figure 6-10, a small bar at the top shows that the current
measure is Gross Profit. This is useful because nowhere else does the chart indicate the current measure.
Not only will measures show here, but if the designer has added filters to the background, such as showing
data only for female customers, the information bar would show the measure and ???Gender: Female.???
Table 6-1 The Options Available to a User when Right-Clicking on a Bar in an Analytic
Report (Continued)
150 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
Territory in them. However, the user could right-click on a bar, choose Drill Down
To, then select Sales Territory, and finally Country. This will show the gross profit
by country for that product line only. This is an important point: the bar on which
the user right-clicks acts as a filter, so the resulting data will only be for that product
line.
Pages:
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212