Edit Table and Pivot Table Views

Tables and pivot tables are commonly used views, and you can edit them in similar ways to display data the way you want.

For example, you can edit a pivot table in an analysis by moving the Brand column to the row edge to display its corresponding Revenue data for each Quarter and Region. You could also display the same data in a more conventional way by adding a table next to the pivot table in a compound layout, as shown below.

Description of views14.gif follows
Description of the illustration views14.gif
  1. Open the analysis for editing.
  2. Click the Results tab.
  3. Click View Properties on the table you want to edit.
  4. Edit the table properties.
  5. Click OK.
  6. Click Edit View to display the Table View editor.
  7. For a pivot table view, click the Graph Pivoted Results button on the toolbar to display the results of the pivot table in a graph view, which is displayed alongside the pivot table.
  8. Click Done.