Contents | Index | Search

• Introduction
  • About SQL Data Analysis
  • Version history
  • Supported database engines
    • Direct connections without client libraries
    • Connecting to an Oracle database without OCI
  • Contact us
• Using SQL Data Analysis
  • The workspace
  • Getting data from a database
    • Running queries to retrieve data
      • Closing a database connection
    • Running queries on the retrieved data sets
  • Opening a data file
  • Using the analysis table
    • Appearance
    • Summaries
      • Advanced summaries
    • Groups
    • Highlighting cells
      • Highlighting options
        • Data bars
        • Icon set
        • Three color scale
        • Two color scale
        • Range of values
        • Duplicate values
        • Ranking
        • Unique values
        • Above or below average
        • Using formulas
      • Formulas
    • Sorting
    • Filtering
    • Analysis chart
      • Chart elements
      • Chart synchronization
    • Printing and exporting
  • Using the pivot table
    • Creating a pivot table
    • Pivot table areas
    • Summaries
    • Custom grouping
    • Filtering
    • Sorting
    • Analysis chart
    • Printing and exporting
  • Creating additional analysis tables or pivot tables
• Frequent tasks
  • Adding more analysis or pivot tables
  • Analysis table
    • Creating a summary
    • Sort using a summary value
    • Grouping columns
    • Stop a column from scrolling
    • Stacking columns
    • Hiding a column
    • Displaying a chart
  • Pivot table
    • Hiding a column
    • Displaying a chart
    • Hiding a chart series