Arrow Storage Products EN106 Guia do Utilizador descarregar pdf (Página 132)

Note:

If you save the connection name, it is displayed on subsequent logins in the Connect to

Data dialog box (see step 3.b.

You are now ready to use Visual Explorer.

4 Under Marks, select Bar from the drop-down list.

5 Drag Year from the Dimension section of the Data window and drop it on the Column shelf.

6 Drag Sales from the Measures section of the Data window and drop it on the Column shelf, placing it to

the right of

Quarter.

7 Drag Profit % from the Measures section of the Data window and drop it on the Color shelf.

At this point, you can see which quarter is the most profitable based on sales as indicated by the

darkest color bar.

8 Drag Region from the Dimension section of the Data window and drop it on the Row shelf.

9 Drag Category from the Dimension section of the Data window and drop it on the Row shelf, placing it

to the right of

Region.

When you drag a generation to a shelf, all generations that are ancestors of the selected generation

are automatically included in this placement. However, if you press and hold down the Control

(Ctrl) key while dragging a generation to a shelf, only that specific generation is included in the

placement.

10 To ignore the Diet Drinks alternate rollup in this analysis, right-click Category in the Row shelf and select

Filter.

Diet Drinks is an alternate rollup that contains shared members. You can deselect it from the

query so that members that are already shown are not redisplayed.

11 In the Filter dialog box, clear the Diet Drinks member and click OK.

12 Expand Category on the Row shelf.

13 Review the visual worksheet.

As shown by the dark green bars in Figure 140, Colas in the East is the most consistently profitable

product based on sales.

132

Advanced Tutorial

1 2 ... 127 128 129 130 131 132 133 134 135 136 137 ... 199 200

Sem comentários

Arrow Storage Products EN106 Guia do Utilizador Página 132