💡💡💡💡Hey Alan. This is great. I would LOVE to see you combine your ADVANCED FORMULA knowledge with the Pivot Table Calculated Field feature! I bet you could unearth some Computergag-ish secrets... I only use simple formulas with calculated fields... is there more?
@@Computergaga I know what you mean! With the power of DAX and the Data Model... routine use of Calculated Items and Fields seems to be on its way to the "Text to Columns Museum" of past solutions! Is there any reason to develop demos of "How to Use Calculated Items and Calculated Fields" anymore? Maybe not! Wait... one day it might be "off" the standard Toolbar and left to the All Commands group of Customize the Ribbon! 😉.
@@PHWiest There is no need for it with better options around. However, it is still a thing, and does a job. I like the Text to Columns museum and visit it often.
Great tips Alan 👌 Rapid inquiry: is it me, or the Pivot Chart Button Icon has been moved to the Insert Tab? Before you can add Pivot Charts from the contextual tab Pivot Table Analyze? Not sure, but this is kind of non-intuitive to go thru the Insert Tab, to add a Pivot Chart for new Excel users.
Thanks Carlos. I still have the PivotChart button on that contextual tab for me. A change that I do like, is when you have a PivotTable active, and you click Insert > normal chart, it gives you a PivotChart. It didn't use to do that. It used to give you a normal chart. Which worked, and is more powerful than PivotCharts, but were not connected to the pivotTable.
Very useful tips&tricks Alan , Thank you I’m wondering that can we combine a normal designed table and pivot table by using Power Pivot or Power Query? Is it possible to analyse data?
Alan, while your presentation is awesome, I have something to say about 11th tip, *"% Difference From."* If the sales report data at column *D* have no hidden decimals then all of the *"% Difference From"* are *not accurate.* You may cross check any one like *February* using appropriate arithmetic. Because of such fallacious results the faith on computer program may decrease. Please do the needful. Thank you.
Awesome! Thank you very much Alan.
Thank you, Gareth 😊
Great tips Alan, very useful, many thanks, kind regards Mohideen
Thank you, Mohideen.
💡💡💡💡Hey Alan. This is great. I would LOVE to see you combine your ADVANCED FORMULA knowledge with the Pivot Table Calculated Field feature! I bet you could unearth some Computergag-ish secrets... I only use simple formulas with calculated fields... is there more?
Thank you, Philip. I guess the data model has surpassed calculated fields now. The DAX language is rich.
@@Computergaga I know what you mean! With the power of DAX and the Data Model... routine use of Calculated Items and Fields seems to be on its way to the "Text to Columns Museum" of past solutions! Is there any reason to develop demos of "How to Use Calculated Items and Calculated Fields" anymore? Maybe not! Wait... one day it might be "off" the standard Toolbar and left to the All Commands group of Customize the Ribbon! 😉.
@@PHWiest There is no need for it with better options around. However, it is still a thing, and does a job.
I like the Text to Columns museum and visit it often.
Easy peasy! Thank you Alan!!!
Thank you, Iván
Thanks Alan for this amazing video.
You're welcome, Syed. Thank you.
Brilliant 🎉🎉🎉 great video
Thank you 👍
Thank you so much
You're welcome 👍
I liked it. Thanks
Thank you, Arun 👍
Great tips Alan 👌
Rapid inquiry: is it me, or the Pivot Chart Button Icon has been moved to the Insert Tab? Before you can add Pivot Charts from the contextual tab Pivot Table Analyze?
Not sure, but this is kind of non-intuitive to go thru the Insert Tab, to add a Pivot Chart for new Excel users.
Thanks Carlos. I still have the PivotChart button on that contextual tab for me.
A change that I do like, is when you have a PivotTable active, and you click Insert > normal chart, it gives you a PivotChart.
It didn't use to do that. It used to give you a normal chart. Which worked, and is more powerful than PivotCharts, but were not connected to the pivotTable.
Very useful tips&tricks Alan , Thank you
I’m wondering that can we combine a normal designed table and pivot table by using Power Pivot or Power Query? Is it possible to analyse data?
Thank you, Emre.
The PivotTable is really the finished article for data so really we would work its source data with another table.
Alan, while your presentation is awesome, I have something to say about 11th tip, *"% Difference From."*
If the sales report data at column *D* have no hidden decimals then all of the *"% Difference From"* are *not accurate.* You may cross check any one like *February* using appropriate arithmetic. Because of such fallacious results the faith on computer program may decrease. Please do the needful.
Thank you.
👍