PivotTable Month on Month % Change + Controversial view on % change from zero! - My Online Training Hub
video description
Date: 2022-04-08
Related videos
Comments and reviews: 10
J.J.
I agree with you! There is a difference between calculating a % change when the data actually shows 0 vs. calculating % change from nothing/no data - which is what happens in the first year.
I mean - what would happen before you start tracking and you try calculating a % change of (0 - 0)/0, which is 0/0 or the infamous -indeterminate-, where you could assign any value as a % to it, since it could be anything since nothing happened in the business yet. It is -nothing over nothing- - on one hand it should be 0, because you are divide 0 by a number. On another hand, it should be 100%, because the numerator is equal to the denominator, etc.
reply
I agree with you! There is a difference between calculating a % change when the data actually shows 0 vs. calculating % change from nothing/no data - which is what happens in the first year.
I mean - what would happen before you start tracking and you try calculating a % change of (0 - 0)/0, which is 0/0 or the infamous -indeterminate-, where you could assign any value as a % to it, since it could be anything since nothing happened in the business yet. It is -nothing over nothing- - on one hand it should be 0, because you are divide 0 by a number. On another hand, it should be 100%, because the numerator is equal to the denominator, etc.
reply
Cryptid
This is very helpful when you have few variables like the months and sales. I have a more complex data set that I need to show both a high level view down to a micro level. In my data set I have a whole budget that gets broken down into many offices. The offices furth spread the budget among various projects. Each project has a unique naming convention to track the budget. On top of that each project has to submit a monthly spending plan we then compare to their actual spending. I need to take the micro detail from the projects and then keep rolling the over data up to higher levels.
reply
This is very helpful when you have few variables like the months and sales. I have a more complex data set that I need to show both a high level view down to a micro level. In my data set I have a whole budget that gets broken down into many offices. The offices furth spread the budget among various projects. Each project has a unique naming convention to track the budget. On top of that each project has to submit a monthly spending plan we then compare to their actual spending. I need to take the micro detail from the projects and then keep rolling the over data up to higher levels.
reply
Rajan
You are kidding when you ask -I hope you find my tutorial useful-, may be because its your sure statement every video. Let me tell you video is not just useful but will make non-finance people also understand why they get negative signs as % change. Awesome.
reply
You are kidding when you ask -I hope you find my tutorial useful-, may be because its your sure statement every video. Let me tell you video is not just useful but will make non-finance people also understand why they get negative signs as % change. Awesome.
reply
clive
Thanks for this, % v actual can be major for me on the % misrepresentation measures, especially when consider absolute, high % -margin- but with small absolute as argument is we do pay staff, suppliers and shareholder with % but with cash-..
reply
Thanks for this, % v actual can be major for me on the % misrepresentation measures, especially when consider absolute, high % -margin- but with small absolute as argument is we do pay staff, suppliers and shareholder with % but with cash-..
reply
Rose
This works perfectly for me an I even shared it with other colleagues. My one question is that my % column and my Change column both show totals at the bottom. In your example the totals are blank. What did I miss?
reply
This works perfectly for me an I even shared it with other colleagues. My one question is that my % column and my Change column both show totals at the bottom. In your example the totals are blank. What did I miss?
reply
Koen
Doing this over multiple years.... makes each january not compare to the previous december values... has to do with the grouping? why does the attribute of -previous- not get applied automatically there ?
reply
Doing this over multiple years.... makes each january not compare to the previous december values... has to do with the grouping? why does the attribute of -previous- not get applied automatically there ?
reply
Savio
Hi Mynda, really informative video.
Also would greatly appreciate a video dedicated to the ''show values as'' feature of pivot tables. Thanks for sharing all of these helpful tips.
reply
Hi Mynda, really informative video.
Also would greatly appreciate a video dedicated to the ''show values as'' feature of pivot tables. Thanks for sharing all of these helpful tips.
reply
Curt
I have Excel on my mac and running Excel 16.57. my drop downs stop at % of Parent Row Total.. So i dont even have the option to select % Differance From??
reply
I have Excel on my mac and running Excel 16.57. my drop downs stop at % of Parent Row Total.. So i dont even have the option to select % Differance From??
reply
Rawad
Problem: When I am inserting a slicer I am loosing the conditional formated column and the labels are going back to numbers. How can I fix this please?
reply
Problem: When I am inserting a slicer I am loosing the conditional formated column and the labels are going back to numbers. How can I fix this please?
reply
Aur-lio
I have got a question for you : what if you work in procurement and you want to represent positive % with a red arrow? (such as cost increase)
reply
I have got a question for you : what if you work in procurement and you want to represent positive % with a red arrow? (such as cost increase)
reply
Add a review, comment
Other channel videos
