Creating the equivalent of a Microsoft Excel PivotTable

This section contains frequently asked questions about Microsoft Excel Pivot Tables.


Creating the equivalent of a Microsoft Excel PivotTable in Quattro Pro

Wordperfect Quattro Pro btnbacktotopproc Creating the equivalent of a Microsoft Excel PivotTable


Question

Does Quattro Pro have an equivalent to the PivotTable feature in Microsoft Excel?


Answer

Yes, Quattro Pro has the CrossTab reports feature, which is equivalent to the Microsoft Excel PivotTable.

You can use CrossTab reports to analyze and organize data located in notebooks and databases. Data does not have to be on the same spreadsheet of a notebook for you to create a CrossTab report. You can connect two or more spreadsheets that contain data and produce a CrossTab report to summarize the data.


To build a CrossTab report
1.
 
Click a spreadsheet cell containing data.
2.
 
Click Tools Wordperfect Quattro Pro onestep Creating the equivalent of a Microsoft Excel PivotTable Data tools Wordperfect Quattro Pro onestep Creating the equivalent of a Microsoft Excel PivotTable CrossTab Wordperfect Quattro Pro onestep Creating the equivalent of a Microsoft Excel PivotTable Report.
3.
 
Drag any fields from the list in the Fields area to any of the following positions in the Layout area:
•
Rows
•
Columns
•
Data
•
Pages
4.
 
Type the report destination in the Destination box.
Unless you select a destination, the CrossTab report is placed in A1 of the next available, unprotected spreadsheet.


More information

For more information about using CrossTab reports, see “Summarizing data by using CrossTab reports.”

Creating the equivalent of a Microsoft Excel PivotTable