Excel Dashboard - Plan vs Actual Variances - FREE Download - My Online Training Hub
video description
Date: 2022-04-08
Related videos
Comments and reviews: 9
Keith
Can you help?!! I want to multiply a pivot table value field that compares this month to last month PPU, giving a variance, by this month's volume (field). Inserting a calculated field doesn't show that value field variance as an option to use, just the base PPU for the month, and -calculated items- are greyed out. Any way to do it in Excel? Want the Pivot to update with that calculated revenue impact of the price change. So its -This month PPU - Last month PPU x this month volume-. Fields: PPU (revenue/volume), volume, revenue, month
reply
Can you help?!! I want to multiply a pivot table value field that compares this month to last month PPU, giving a variance, by this month's volume (field). Inserting a calculated field doesn't show that value field variance as an option to use, just the base PPU for the month, and -calculated items- are greyed out. Any way to do it in Excel? Want the Pivot to update with that calculated revenue impact of the price change. So its -This month PPU - Last month PPU x this month volume-. Fields: PPU (revenue/volume), volume, revenue, month
reply
Swim
We work a lot with scatter plots and bi-plots (PCA), comparing samples (>2 at a time). The whole purpose is to compare results (hedonics, just-about right, meet expectations, purchase intent, etc.) presenting simultaneous results for all samples tested (it could be 2 or 4 or 5 samples). Do you know if Excel dashboard can handle that?
reply
We work a lot with scatter plots and bi-plots (PCA), comparing samples (>2 at a time). The whole purpose is to compare results (hedonics, just-about right, meet expectations, purchase intent, etc.) presenting simultaneous results for all samples tested (it could be 2 or 4 or 5 samples). Do you know if Excel dashboard can handle that?
reply
Rodrigo
Hello. Very nice video. I have a question: why insert a calculated field in the pivot table instead of adding a column to the original data table with a formula to obtain the information you're looking for?
reply
Hello. Very nice video. I have a question: why insert a calculated field in the pivot table instead of adding a column to the original data table with a formula to obtain the information you're looking for?
reply
Oleksandr
Hi Mynda. Thank you for your work. Can you please explain what's the difference between Plan and Forecast figures? Why are they different and what's the meaning behind them?
reply
Hi Mynda. Thank you for your work. Can you please explain what's the difference between Plan and Forecast figures? Why are they different and what's the meaning behind them?
reply
Richard
This. Is. Awesome. This is just what I have been searching for. Always was a pivot table fan and you just made it so easy to go to the next level!! Sharing with my team.
reply
This. Is. Awesome. This is just what I have been searching for. Always was a pivot table fan and you just made it so easy to go to the next level!! Sharing with my team.
reply
Lee-Anne
I love all your tutorials and its helped me build my own custom teams dashboard. I wondered if there is a way to allow data entry in pivot tables?
reply
I love all your tutorials and its helped me build my own custom teams dashboard. I wondered if there is a way to allow data entry in pivot tables?
reply
Abo
Hi I Downloaded this ex sh from website but i can not remove the box even i hold ctrl +left click + dele kindly advice me to open this wonderful sheet
reply
Hi I Downloaded this ex sh from website but i can not remove the box even i hold ctrl +left click + dele kindly advice me to open this wonderful sheet
reply
HASNAT
I watched your every video thanks a lot for interactive presentation may I have your email address to get in touch with you ? Thanks in advance
reply
I watched your every video thanks a lot for interactive presentation may I have your email address to get in touch with you ? Thanks in advance
reply
regi
You videos have been beyond helpful - I spend the majority of my dashboard time trying to develop a -layout-. Do you have any recommendations?
reply
You videos have been beyond helpful - I spend the majority of my dashboard time trying to develop a -layout-. Do you have any recommendations?
reply
Add a review, comment
Other channel videos
