Pivot tables are used in data processing and are found in data visualization programs such as spreadsheets or business intelligence software. Such programs can automatically sort, count, total or average the data stored in one table or spreadsheet, displaying the results in a second table -- the pivot table -- showing the summarized data. The user often sets up and changes the summary 's structure by dragging and dropping fields graphically. This "rotation '' or pivoting of the summary table gives the concept its name.
when do we use pivot table in excel
in data processing in data visualization programs