From the course: Excel Formulas and Functions Quick Tips
Join today to access over 24,800 courses taught by industry experts.
Use PIVOTBY to aggregate data with more columns - Microsoft Excel Tutorial
From the course: Excel Formulas and Functions Quick Tips
Use PIVOTBY to aggregate data with more columns
- [Narrator] The PIVOTBY function is similar to GROUPBY. You can aggregate data and display it like a pivot table. It's also only available for Microsoft 365 users. PIVOTBY has one extra required field. A specific column that you want to see the data for. The first parameter is what we want to group. I want to see the product categories. The second parameter is the specific one for PIVOTBY. This is a specific column that you want to see the data for. In this case, I want to see which ones sold that we're wholesale versus retail. The third parameter is what we're going to be actually looking at. In this case, the quantity of units sold and the last required parameter is how I want to see that data, and because I want to see the total quantity sold, that's a sum. For this PIVOTBY, I'm going to use one of the optional parameters, and that's to show the headers. As soon as I hit the Enter key, I can see all of my quantity sold, grouped by retail and wholesale.
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.