Share this Page URL

Chapter 11. Analyzing Data with PivotTab... > Changing the View of Data in a Pivot... - Pg. 388

Analyzing Data with PivotTables and PivotCharts 388 Clicking this button removes the filters we've applied (and would apply the filters again, if you clicked it again). The PivotTable now displays its full set of records, and you can begin selecting other sets of records. Analyzing Data in a PivotTable Filtering data in a PivotTable to display a specific segment of data is just one of the operations that make PivotTables an effective data analysis tool. Among the other ways in which you can modify how a PivotTable displays data is to hide or show detail items or collapse or expand row fields when a PivotTable includes both an inner and an outer row field. You can use commands on the PivotTable menu (and corresponding buttons on the PivotTable toolbar) to perform these operations as well as operations that affect which data the PivotTable displays. Here's a list of PivotTable operations. In the steps that follow the list, we'll show several of the operations in action. · Show Top/Bottom Items Display only a certain number or a certain percentage of the top or bottom values for a selected field. In our example, you could display only the 10 products with the highest sales revenue. · AutoCalc Calculate subtotals or other aggregate values in a column using one of the standard functions such as Sum, Count, Average , and so on. · Subtotal Insert subtotals for a row. · Calculated Totals And Fields Add a calculated field or a data total by using an expression. · Show As View summary data (such as a subtotal) as a percentage of a grand total, as a per- centage of the values in a row, as a percentage of a column, and so on. Analyze data in a PivotTable