Add a Pivot

  1. Click on the desired data field.
  2. The Pivot dialog box displays.

  3. Begin typing the alias name of your column in the Column Name box .
  4. Select one of the following:
    • Multi Column: By default, Multi Column is selected. Presents your pivot value within multiple columns.
    • Single Column: Presents your pivot value in one column.
  5. Click or type the desired Pivot on Dimension.
  6. Click or type the desired measure.
  7. Click or type the desired Group By.
  8. Click the Add button to add a new Pivot option.
  9. Click Apply to save your changes and return to the previous page. Alternately you can Cancel your changes and return to previous page.