To display specific values in a PivotTable in Microsoft Excel, use one of the many built-in filters, such as Top 10. Image: muchomor, Getty Images/iStockphoto Must-read Windows coverage ...

The grouped Excel PivotTable is useful enough as is, but you might want to display invoiced items. To do so, do the following: In the PivotTable, select the grouped values.