Only Excel PRO's know these Pivot Table features

Check out my full courses and ebooks here:
👉 www.howtoexcel.org/courses/
DOWNLOAD any example workbooks here:
📖 www.howtoexcel.org/downloads/
SUBSCRIBE & get my 3 FREE eBooks.
📧 www.howtoexcel.org/newsletter/
CONNECT with me on social:
Facebook: / howtoexcelblog
Twitter: / howtoexcelblog
LinkedIn: / john-macdougall
Thanks for all your support!

[@HowToExcelBlog]

Check out my full courses and ebooks here:
👉 www.howtoexcel.org/courses/

[@islamelkhateeb6524]

Amazing, I enjoyed the last part starting from precent of grand total and precent of category
Pivot chart was new to know for me
Thanks for sharing

[@NealHartsChannel]

I checked the "Add this data to the Data Module" when I created my pivot table. Now mine are set to count for some reason. On right click all of my 'summarize vales by' are greyed out. I have numbers in the cells, but I can't seem to change it. If I go to the value field like you did in the first example and try to change it, I get an error message - we can't summarize this field with average because it's not a supported calculation for text. But the cells are numbers. Do You have any idea how to correct this?

[@vdpeer]

The "groupby" function will do some of this.

[@HowToExcelBlog]

Indeed, PIVOTBY is also a good option.

[@bobbychan2086]

I didn’t find anything advance with video, very basic, let’s start with get pivot and calculated fields