Excel

PivotTables

PivotTables are a function that allows the user to simplify the organization and summarization of a large amount of data. They also provide unique views of the data set as constructed by the user. Among the many possibilities are sorting, counting, totaling, and averaging a large amount of data in one table. All results are constructed in a new table to aid in creating a report for a specific situation as designed by the user. They derive their name from the rotating, or “pivoting,” of data fields graphically to create a new structure providing a unique view of the raw data set.

PivotTables are not created automatically, so the users must design each one specifically to meet their analysis needs. The fields must first be defined, then the raw data in the main table must be assigned to one of the given fields. These fields are typically provided for selection as row or column headers and defined as a report filter, column label, row label, or summation value. Once the fields are defined and the pivot table designed, the user can customize reports based on the needs of the requesting agency or entity. Pivot tables can be a very powerful tool; however, they are intricate in their design, so ensuring there are no errors in the raw data and construction is critical. Error codes are provided if a faulty design exists and the “Help” function will allow for swift analysis of the design flaw.

...