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.

Learn how to use calculated fields and items in Excel PivotTables to enhance your data analysis skills and uncover actionable insights.

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

Yesterday, the Excel team announced a bunch of performance improvements in Excel 2016 for PivotTables connected to Analysis Services (Multidimensional or Tabular), Power Pivot and Power BI. If you … ...