Go Deeper with PivotTables | Multiple Fields, Show Values As & Drill Down

📁 Want to follow along? Download the free PivotTables practice file here: https://www.marg-analytics.com/post/p... In this video, I’ll show you how to go deeper with PivotTables by adding multiple fields, using Show Values As, changing the report layout, and drilling down into the source details. You’ll learn how to: add multiple fields into a PivotTable use Show Values As to add extra calculations for comparison change the PivotTable report layout drill down into the source records behind a PivotTable value This is Part 4 of my PivotTables series, where I cover the fundamentals step by step so you can start analysing data more confidently. ⏱️Video Chapter 00:00 Introduction 00:07 Multiple fields 02:28 Show Values As 05:01 Layout 09:53 Drill Down #excel #pivottable #marganalytics