<P> 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 . </P>
<P> 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 . </P>
when do we use pivot table in excel
when do we use pivot table in excel
in data processing in data visualization programs
in data processing in data visualization programs