About pivot tables

A pivot table is a tool to summarize, organize, sort, reorganize, group, count, total, or average selected rows and columns of data in a spreadsheet or database table by dragging and dropping data fields. A pivot table doesn't actually change the spreadsheet or database itself, but it does allow you to transform columns into rows and rows into columns and allows grouping by any data field. Because pivot tables summarize data, you can use them to find unique values in a field—this is an excellent way to quickly see all the values that appear in a field and find typos or other inconsistencies. You can use pivot tables to create charts and reports.

When data is returned from a DataMiner data source, one of the tabs you see at the bottom of the window is Pivot Table. Available data fields from the selected data source are shown at the top of the DataMiner window.

...