Once you have created the basic layout of your PivotTable or PivotChart report, you have laid the groundwork for creating a vast range of summary reports and charts. In this chapter, you will learn how you can edit your PivotTable or PivotChart report so that it displays your information your way. As with lists and tables, you can sort and filter the data within your PivotTable to control which items are shown and the order in which they are displayed. You can also change the settings for a field to alter the function used to summarize data or to amend the layout of the data within the field, or if you want to perform any custom calculations on a PivotTable, you can insert a calculated field or a calculated item. The location of the PivotTable or PivotChart and the source of the data can also be updated, and you can quickly remove any filters or clear a PivotTable entirely so that you can begin constructing it again. By the end of this chapter, you could find that PivotTables are the only data analysis tool you’ll ever need.
Unable to display preview. Download preview PDF.