The dialog box
contains a number of tabs that allow users to change how the values are actually
displayed, change the column, row, and grid colors, and change the grid font. Along
the left-hand side of the dialog box are options to modify the grid, add a title, or
modify the drill to detail behavior. Figure 6-39 further shows that the developer
has chosen to display the percent of total next to the actual values (which are on by
default.) The change has been applied and the results are visible on the grid in the
background. From this example it is easy to see that bikes accounted for 78% of
total sales in 2003, but so far in 2004 they are accounting for 86% of sales. The grid
has a grand total at the bottom added automatically when the percentage is being
displayed. Percentages can be turned on for the columns, rows, or both.
Figure 6-38 A simple ProClarity grid with All Products expanded to show its children
without replacing the parent, while Calendar has been drilled down to the
Year level
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 183
NOTE
It??™s important to understand that right-clicking on different parts of the grid can bring up slightly
different menus. Figure 6-40 shows three different menus that can be brought up by right-clicking.
The one on the top left appears when a user right-clicks on a member in the rows or columns. The
menu on the top right appears when a user right-clicks on a data cell in the grid.
Pages:
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245