Creating Pivot Tables | CLEARIFY

Creating Pivot Tables and Analysis in Excel

Pivot Tables provide the most effective method of analyzing dynamic data, and the QQube Excel Add-In gets you up and running in a matter of seconds.

Clicking on a field from the QQube Excel Add-In will add it as a field to be used in the Excel Pivot Table list of fields. (Click here for detailed instructions on this procedure.)

In This Section

• Strengths/Limitations
• Components
• Report Layout
• Design Styles
• Formatting Features
• Subtotals
• Grand Totals
• Show/Hide Options
• Naming Columns
• Data Value Options
• Drill Down Functions
• Custom Groups
• Global Options
• Calculated Fields
• Tips & Workarounds