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

Before we dive into pivot tables in Excel, letâ s have a quick word about it. A pivot table is a powerful tool in Excel to summarize and analyze your vast database in different ways.