From the course: Excel PivotTable Quick Tips (2022)
Join today to access over 24,700 courses taught by industry experts.
Summarize values in a PivotTable - Microsoft Excel Tutorial
From the course: Excel PivotTable Quick Tips (2022)
Summarize values in a PivotTable
- [Instructor] We can show summary values of this quantity data. In this column, I can right click on any cell and hover my mouse over Summarize values by. Here, you can see the count, average, max or min or product of the values. You can also hover your mouse over Show values as. From here, you can see calculations such as the percentage of the grand total, apparent row total, differences. You can even rank from smallest to largest and backwards. If I changed those values to this quantity field, I wouldn't see what the original values are. So what I could do in a pivot table is double up on this column. I already have the quantity in the values area, but I can click and drag it over again. It's going to duplicate the column. And in this column, I can summarize the values. For example, I'll rank them from smallest to largest. I'll base it off of the product category. And here's my ranking. This is the smallest quantity.…
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.
