Duplicating Tables and Crosstabs

Duplicating tables and crosstabs provides a quick, easy way to present still more perspectives on the data. You might, for example, want to duplicate an existing table so that you can use the analytical properties offered by pivoting on a crosstab layout or vice versa.

See also:
Pivoting Data
Drilling Into and Out of the Data
Sorting Data
Adding Calculations to Worksheets
Totaling Numeric Data
Calculating Percentages


To duplicate a crosstab as a table, or vice versa:

1. Open the worksheet that you want to duplicate.

2. From the menu choose Sheet | Duplicate a Table or Sheet | Duplicate as Crosstab. The dialog box for duplicating the table or crosstab appears.

   The dialog box appears with the Table Layout tab or Crosstab Layout tab selected depending on the duplication you're doing.

3. Indicate which items you want to display in the new table or crosstab:

   Show Page Items--show/hide the page items box on the table or crosstab. If page items already exist for the worksheet, Discoverer disables this option and shows the page items portion of the worksheet.

4. Arrange the columns and page items so the duplicated table or crosstab appears as you want it.

5. Click OK.