Pivots Ardent X shows the data from a grid in a standard pivot. the pivot can be manipulated as required. you can export the pivot to excel

A pivot table is a program tool that allows you to reorganize and summarize selected columns and rows of data in a spreadsheet or database table to obtain a desired report. A pivot table doesn't actually change the spreadsheet or database itself.