Among other functions , a pivot table can automatically sort , count total or give the average of the data stored in one table or spreadsheet , displaying the results in a second table showing the summarized data .
A pivot-table can automatically sort , total or give the average of the data stored in a table . It displays the results in a second table ( called a `` pivot table '' ) .