Pivot Table

pivot table  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 Insert a Pivot Table · 1 Click any single cell inside the data set · 2 On the Insert tab, in the Tables group, click PivotTable Insert Excel Pivot Table

Sample data The sample data contains 452 records with 5 fields of information: Date, Color, Units, Sales, and Region This data is perfect for a pivot table  Structure VALUE Hierarchy · Select the pivot table · Plot at least two columns under VALUE When you do this, a box labeled VALUES will appear under PIVOT

In order for this data to work for a pivot table, you should have: • No blank rows or columns, • No data outside of the list , and • Creating a pivot table · From the assets panel, drag an empty pivot table to the sheet · Click Add dimension and select a dimension or a field · Click Add