Arrow Storage Products EN106 Betriebsanweisung PDF herunterladen (Seite 45)

Figure 25 shows the spreadsheet view before pivoting.

Figure 25 View Before Pivoting

5 In cell C3, select Year and select Essbase > Pivot.

Essbase pivots the Year dimension to a column group next to Market (above the Scenario

members), as shown in Figure 26.

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

6 As another example, in cell C2, select Actual.

7 Right click and drag Actual to product 100 in cell A3.

As Figure 27 shows, the member label box is displayed under the cursor during the pivot

operation, and it displays the names of the members that you are pivoting. The orientation of

the member label box, however, does not determine the orientation of the pivot result. Essbase

determines the data orientation by the location of the destination cell.

Pivoting, Retaining, and Suppressing Data

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

Keine Kommentare

Arrow Storage Products EN106 Betriebsanweisung Seite 45