Excel - FX RaggruppaPer e PIVOTPER

In this lesson we will see how the GROUBY function in Excel works. We will try to understand the advantages and disadvantages compared to the classic pivots and we will go into detail on how it is possible to fill in the parameters of the function The function is currently only available on the M365 Insider channel, we hope it arrives soon in the current channel!! =========== INVEST IN YOUR TRAINING ================= Are you looking to improve your skills and obtain a digital certificate of attendance? My Masterclasses offer exclusive content and a complete learning experience. By purchasing from my site you will also have access to exclusive discounts. Don't miss the opportunity to grow professionally. https://www.bi4you.it/masterclass/ =========== SUBSCRIBE ON YT ================= Subscribe to this channel to access the benefits:    / @lodovicodincau   ======= SAFE AND AFFORDABLE SOFTWARE! == CyberGhost VPN/Antivirus TOP: https://www.cyberghostvpn.com/offer/B... Windows, Office, WindowsServer, SQL Server: https://mrkeyshop.com/it/?MrKey=484 ======= MY GEAR =============== Mouse: https://amzn.to/3Tnu1Kk Yeti Microphone: https://amzn.to/3YWIM8h Standless Microphone: https://amzn.to/3ZXDSci Yeti Filter: https://amzn.to/3mZfkRF Sony Alpha 6400L: https://amzn.to/42niFu8 Elgato Stream Deck: https://amzn.to/3Tm94Q8 Elgato Cam Link 4K: https://amzn.to/3yMOEGo Elgato Facecam: https://amzn.to/3TqL0eX TC Helicon Mixer: https://amzn.to/3Tmzf9p RGB Keyboard: https://amzn.to/3JQaOOx 2k Gaming Monitor: https://amzn.to/3yNJWs2 Switch: https://amzn.to/3JQftQA My name is Excel: I solve problems: https://amzn.to/3LxkrD4 DAX book in Italian: https://amzn.to/3TGHj4L The Definitive Guide to DAX: https://amzn.to/3JLunYe Prime Student 90gg free: https://amzn.to/3YWDwBm ============ R I S O R S E =================== Channel Index - Available to subscribers only: https://docs.google.com/spreadsheets/... Download Abb: https://docs.google.com/spreadsheets/... Lesson Chapters: 00:00 Introduction 00:24 Advantages and disadvantages 00:50 Custom Guide 02:31 Row_Fields parameter 07:39 Values ​​parameter 09:20 Function parameter 10:10 Field_Headers parameter 11:11 Total_Depth parameter 13:18 Sort_Order parameter 15:04 Filter_Array parameter 15:34 Dynamic filter type 1 18:15 Dynamic filter type 2 21:22 Greetings #GROUPBY #EXCEL #PIVOT