Create Pivot tables in
SQL Server

Create a Pivot Table

With the Pivot Table Designer, you can manipulate the data stored in a database in many different ways

dbForge Studio for SQL Server allows creating Pivot Tables visually by simply dragging-and-dropping the required columns into the corresponding areas of a Pivot Table.

Once you have created a Pivot Table, you can reorganize it as many times as you need to understand data relations and dependencies in the best possible way.

Reorder Fields in a Pivot Table

The ability to change the layout form of a pivot table is crucial in making data easier to read and scan for details.

The Pivot Tables created with the help of the Pivot Table Designer are dynamic, which means that they can be easily be reorganized. In just a few clicks, you can create as many pivot tables as you need.

In dbForge Studio for SQL Server, a simple mouse drag will immediately rearrange the Pivot Table according to your needs and make it look the most suitable way.

Filter Data in a Pivot Table

To get a better insight into your database data, you can use filters to display only the required data in a pivot table.

With the Pivot Table Designer, you can add filters to filter all the data in the pivot table. Also, you can use the PivotGrid Prefilter option to apply advanced filtering conditions to filter data.