A Pivot Table has four panels in the Widget Data Editor:

 

Rows: Members placed on this panel will make up the rows of the Pivot Table.

Columns: Members placed on this panel will make up the fields (columns) of the Pivot Table.

Measures: The Measures whose values are shown in the Pivot Table.

Background: The Members that slice the data, but will not show as rows or fields.

---

Any Dimension, Group or Filter can be placed on all panels except for the Measures panel that accepts Measures only.

---

Placing data on the Background panel while data from the same Dimension is placed on either Rows or Columns panels will result in intersection operation between the two panels.  Only Members appearing in both will be returned.

---

The order in which fields appear is determined by the order of their appearance in the panel.  You can reorder the fields by clicking on the appropriate Dimension and dragging it to its new location.

---

See Also