Only Excel PRO's know these Pivot Table features 

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

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

The "groupby" function will do some of this.

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?

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