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

Figure 32 Result of Retaining a Data Subset (Adjacent Cells)

Occasionally, the data that you want to remove from the worksheet does not lie in an adjacent

range of cells.

➤ To select and retain nonadjacent cells:

1 Press and hold down the Alt key, and, in cell D1, zoom in (double-click) on Year.

2 Select Qtr2 in cell E2.

3 Press and hold down the Ctrl key and select Qtr4 in cell G2 (see Figure 33).

Figure 33 Selecting Nonadjacent Members for the Keep Only Command

4 Select Essbase > Keep Only.

Essbase retains only Qtr2 and Qtr4 data and deletes the other Year members, as shown in

Figure 34.

Basic Tutorial

1 2 ... 43 44 45 46 47 48 49 50 51 52 53 ... 199 200

Sem comentários

Arrow Storage Products EN106 Guia do Utilizador Página 48