PivotTable Month on Month % Change + Controversial view on % change from zero!

Calculating the month on month or year on year percentage change in a PivotTable is easy, but often people make a common mistake when handling calculations from zero. In this video I'll show you the correct way to handle change from zero and show you how to build an interactive PivotTable with Conditional Formatting to make it easier to visualise.

Download the file here: https://www.myonlinetraininghub.com/e...

0:00 Introduction
0:30 Month on Month % Change PivotTable
1:46 Conditional Formatting to show change
3:43 Show Items with no data
3:55 Handling Errors in PivotTables
4:10 Removing Greater Than and Less Than Items from Grouped Dates
4:27 Calculating % Change from Zero
4:57 % Change Formula
5:28 Correct way to represent % change from zero
6:01 Incorrect ways to represent % change from zero
7:44 Calculating % change with negative values

View our comprehensive courses: https://www.myonlinetraininghub.com/

Connect with Mynda on LinkedIn:   / myndatreacy