XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/

Dragging and Dropping in Grids

One of the quickest ways to change a Grid report is to use the drag and drop feature. This allows you to drag and drop hierarchies between the rows, columns and header axes of the report, allowing you to quickly produce detailed reports.

  1. Click and hold the left mouse down on the hierarchy you want to move:
  2. DragDrop1.png
  3. As you move the mouse over the other hierarchies, the cursor will change. In this example, we are swapping the two hierarchies:
  4. DragDrop2.png
  5. Release the mouse button to complete the operation:
  6. DragDrop3.png

When over other hierarchies, the drop indicator will change to indicate whether the dropped field will be placed before or after the current field, or whether they will swap positions:

DragDropIcon(Swap).png Swap selected hierarchy with this one
DragDropIcon(Left).png or DragDropIcon(Above).png Move selected hierarchy before this one
DragDropIcon(Right).png or DragDropIcon(Below).png Move selected hierarchy after this one