The
hierarchies placed on the series or category areas can be expanded so that multiple
selections can be made. The chart itself is interactive and double-clicking expands
the data (it does not drill down) although buttons at the top of the chart allow for
collapsing, expanding, drilling into, and drilling out. There are also buttons for
filtering, sorting, and pivoting, and there is an area at the top of the chart for filters
Figure 6-22 A PivotChart showing the rich chart types and a list of the fields available in
the Adventure Works cube. The downside of a PivotChart or PivotTable is the
need for client-side software installation.
C h a p t e r 6 : A n a l y s i s w i t h P e r f o r m a n c e P o i n t S e r v e r a n d P r o C l a r i t y 165
(similar to filters on a dashboard as shown in Chapter 5.) Figure 6-23 shows a
standard bar chart with Gross Profit for the four years for all products.
PivotTables are very similar. There is an area at the top that holds filters, and
areas for data on the rows and columns. Multiple measures can be placed in the grid
itself. Buttons allow for sorting and filtering, and there are a host of options on the
Command and Options dialog box to show and hide certain items, as well as control
formatting. Note that subtotals can easily be placed on the grid and developers can
choose to hide or show rows and columns where all the values are empty. At both
design time and runtime, columns can easily be resized to show all the data or the
full text in the header.
Pages:
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227