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

Slicers are a great tool for filtering a data set or PivotTable. Learn how to use one slicer to manipulate more than one PivotTable or PivotChart.

How to use Excel's new Cube-based functions and conversion tools to convert a PivotTable to a formula-based report.

Excel's PivotTable feature is a fantastic option for data analysis, allowing users to consolidate and analyze data from various sources in a single, ...

You can add a calculated column in Power Pivot, unless it contains a formula. Get & Transform (Power Query) Improvements have also been made to Get & Transform (also known as Power Query): New and ...

Several readers have submitted questions about Excel 2010 and 2007 PivotTables, as follows: Q1: Why does Excel insert the GETPIVOTDATA function into a formula when you use the mouse pointer to refer ...