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

Figure 34 Result of Retaining a Data Subset (Nonadjacent Cells)

Removing a Data Subset

The Remove Only command is the counterpart to the Keep Only command. With Remove Only,

you can remove selected member rows or columns and retain all other data in the worksheet

view.

➤ To remove a data subset from the current worksheet view:

1 In cell B7, select Ratios.

2 Press and hold Ctrl, and, in cell B9, select Measures.

3 Select Essbase > Remove Only.

Essbase removes data for Ratios and Measures but retains data for Profit and Inventory. The

result is shown in Figure 35.

Figure 35 Result of Removing a Data Subset

Navigating Through the Worksheet Without Retrieving Data

With the Navigate Without Data feature, you can perform navigational operations, such as pivot,

zoom in, zoom out, keep only, and remove only, without retrieving any data into the worksheet.

Pivoting, Retaining, and Suppressing Data

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

Sem comentários

Arrow Storage Products EN106 Guia do Utilizador Página 49