Data analysis
Last modified: July 22, 2025
This section provides tools and techniques for analyzing data using pivot tables and the Master-Detail Browser. It covers creating pivot tables and charts, organizing fields through sorting, grouping, and filtering, applying summary functions, and customizing layouts with conditional styles. Guidance is also included for printing pivot tables and understanding key components such as headers, totals, and data areas.
In this section
- Pivot table overview
- Create a pivot table
- Create a chart in a pivot table
- Reorder fields
- Filter fields
- Sort fields
- Group fields
- Use summary functions to calculate custom totals
- Apply conditional styles
- How to print a pivot table
- Areas
- Filter field
- Headers
- Column field
- Row field
- Data field
- Totals
- Grand totals
- View data in related tables
- Work with self-referencing tables in Master-Detail Browser
- Work with a Master-Detail Browser document
- Sort and filter data in Master-Detail Browser
- Tips for working with Master-Detail Browser
Was this page helpful?
Want to find out more?
Overview
Take a quick tour to learn all about the key benefits delivered by dbForge Studio for SQL Server.
All features
Get acquainted with the rich features and capabilities of the tool in less than 5 minutes.
Request a demo
If you consider employing this tool for your business, request a demo to see it in action.