From the course: Excel: PivotTable Tips
Unlock this course with a free trial
Join today to access over 22,600 courses taught by industry experts.
Grouping values - Microsoft Excel Tutorial
From the course: Excel: PivotTable Tips
Grouping values
- [Instructor] I want to take a few minutes to talk about a pivot table pro tip that I actually didn't discover until quite recently, and that's how to use pivots to group numerical values. Now, many people are familiar with grouping text fields or dates in pivot tables, but what most users don't realize is that you can also group numerical fields into custom bins or buckets. Now, to do this, what we're going to do in this demo is we're going to pull a numerical field into our row labels, like this. In this case, we're looking at the price point per bottle of wine. And this feels a little bit wrong because we're always taught to pull those quantitative, those numerical fields, into the values pane of our field list, not into rows or columns. But in this case, that's exactly what we want. And what we're going to do is right-click one of the values in this column and navigate to the group option, just like we would with a date or a text field. But the difference is that this dialog box…
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.
Contents
-
-
-
Customizing the field list4m 7s
-
(Locked)
Autofitting column width4m 21s
-
(Locked)
Outline and tabular layouts7m 46s
-
(Locked)
Counting nonnumerical fields6m 5s
-
(Locked)
Grouping dates8m 3s
-
(Locked)
Enabling multiple filters5m
-
(Locked)
Grouping values6m 50s
-
(Locked)
Adding value calculations9m 1s
-
(Locked)
Showing empty items6m 22s
-
(Locked)
Configuring slicers and timelines10m 23s
-
(Locked)
Conditional formatting8m 23s
-
(Locked)
Removing and reviving source data8m 19s
-
(Locked)
Adding custom sort lists5m 23s
-
(Locked)
Solve order and list formulas6m 16s
-
-