Pivoting enables you to transpose rows or columns groups and move data from rows to columns and from columns to rows using a drag operation.
To pivot data:
Select Essbase, and then Pivot.
Alternatively, press the secondary mouse button and drag the selection to the destination cell. Release the mouse button after you reach the destination cell.
The member label box is displayed under the cursor during the pivot operation, and it lists 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.
Whenever the source cell and the destination cell are members of different row groups, Essbase exchanges the member groups. You must select a destination cell containing a member name to exchange row members. You can also exchange column members by choosing a destination cell in another column containing a member name.
Using Mouse Actions to Pivot, Retrieve, and Drill Up and Down