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

At the sheet level, conditional running totals require focused expressions, but an Excel PivotTable requires only a few field swaps. Susan Harkins shows you how.

In this situation, you might consider converting your PivotTable to a formula-based report using Excel 2016’s new Cube-based functions and conversion tools. Once converted to formulas, your report is ...

Instead of using complex formulas or writing lengthy code, you can drag and drop fields into a PivotTable to instantly see summaries based on different variables.

If you double-click a value in a PivotTable to drill down, Excel extracts the values that contributed to it, placing them into a new sheet. PivotTables have a built-in drill-down feature.

By mastering these advanced Excel PivotTable techniques, you can optimize your data analysis and visualization processes, making your reports more efficient, flexible, and visually appealing.

Currently, the GROUPBY function is available only in Microsoft Excel 365. If you would like to follow along in using this function, you can download this Excel workbook and view the video at the end ...

In Excel there are tables and PivotTables. You may wonder why you'd need to create a table when the whole worksheet already looks like one. And you've heard about PivotTables and how complex they are.