Share this Page URL

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

Analyzing Data with PivotTables and PivotCharts 5. 6. 390 On the toolbar, click the AutoFilter button so that the PivotTable removes the current filter and displays the complete set of data. Click the column heading Sum Of OrderAmount. Click the Show As button on the toolbar, and then select Percent Of Column Total. By using the Show As button, you can shift the PivotTable so that it shows numeric subtotals as a percentage, which provides a different way to compare data. For example, as shown here, orders for Alice Mutton are a little over 3 percent of the total orders. While the number of orders for Alice Mutton has increased (1997 and 1998 have more rows than 1996), which resulted in more revenue from the sale of that product, the percentage has trended downward, falling from over 4 percent of total orders in 1996 to less than 3 percent in 1998. This is the sort of analysis that PivotTables are designed to provide, and no additional design work in either the underlying query or the form is required. You could, of course, filter the data (by country, in this example) to see how orders compare in just one country or in a selection of countries.