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
Watch video PivotTable Month on Month % Change + Controversial view on % change from zero! online without registration, duration hours minute second in high quality. This video was added by user MyOnlineTrainingHub 04 November 2021, don't forget to share it with your friends and acquaintances, it has been viewed on our site 42,55 once and liked it 1.1 thousand people.