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

Figure 27 Pivoting a Column Group to a Row Group

Figure 28 shows the result of Essbase pivoting the Scenario members (Actual, Budget, Variance,

and Variance%) from a column group to a row group that is displayed to the left of the Product

members.

Figure 28 Result of Pivoting a Column Group to a Row Group

➤ To transpose the order of row groups:

1 In cell A2, select Actual.

2 Right-click and drag Actual to Profit in cell C2.

Figure 29 shows the spreadsheet before the pivot operation.

Figure 29 Pivoting the Order of Row Groups

The pivot changes the order of the row groups. The result is shown in Figure 30

Basic Tutorial

1 2 ... 41 42 43 44 45 46 47 48 49 50 51 ... 199 200

Sem comentários

Arrow Storage Products EN106 Guia do Utilizador Página 46