5 Problems with PIVOTBY vs Pivot Tables in Excel

Microsoft recently introduced two new functions for Excel: GROUPBY and PIVOTBY. While these new features offer exciting possibilities, they come with their own set of challenges. DOWNLOAD THE WORKBOOK ► https://www.excelcampus.com/functions/5-problems-with-excels-new-pivotby-function/ NOTE: The PIVOTBY and GROUPBY functions are currently available on the Beta Channel for Microsoft365 subscribers. They might still be flighted, which means only a portion of users on beta will see the functions. They will eventually roll out to all beta users, then to the other channels. 🔗LINKS 🔎 Get free weekly Excel tips: https://www.excelcampus.com/newsletter/ 💡 Free 60-minute Excel training session: https://www.excelcampus.com/blueprint 📖 Join Our Comprehensive Excel Training Program: https://www.excelcampus.com/elevate Related Content: ✅ Using Formulas When Pivot Tables Are a Better Option https://youtube.com/shorts/x4S5tCdZtVE ✅ 3 Amazing Tips For The Pivot Table Fields List https://youtu.be/PQqfugKkzck ✅ Excel’s Missing Feature: Slicers for PIVOTBY https://youtu.be/82mMdIDxQfQ ✅ Create A High Low Stock Pivot Chart In Excel https://youtu.be/lSFFQJj14Z4 ✅ Refresh Pivot Tables Automatically with a Macro https://www.youtube.com/watch?v=NI1UQcYtl1A 00:00 Introduction 00:57 Problem #1 Complexity 01:58 Problem #2 Formatting 04:30 Problem #3 Percent of Total 05:52 Problem #4 Pivot Charts Slicers 07:28 Problem #5 Flexibility