Year-to-Year (YoY) in an Excel PivotTable
3 ways to compare year-over-year in a pivot table: using calculated fields, formulas, and measures in the Power Pivot Data Model.
Download example https://www.planetaexcel.ru/technique...
Contents:
(01:00) - Building and configuring a pivot table
(04:00) - Calculating year-over-year using a calculated field in the pivot table (Method 1)
(10:30) - Calculating year-over-year using formulas outside the pivot table (Method 2)
(12:40) - Using measures in the Data Model (Method 3)
My books http://planetaexcel.ru/books/
My online courses https://www.planetaexcel.ru/learning/
My PLEX add-in (+150 new functions for your Excel) http://planetaexcel.ru/plex/
Subscribe to our Telegram channel to quickly learn about all the new features and life hacks for working in Excel - https://t.me/planetaexcel