To display specific values in a PivotTable in Microsoft Excel, use one of the many built-in filters, such as Top 10.

One of the advantages of using Excel as your spreadsheet application is that you can display a simple piece of information just as effectively as a complicated collection of data. For instance ...