Okay, so let's have a look at pivot table grouping now. So in this pivot table, we've got at the bottom here, we've got salesperson cross-tabbed with our products and then we've got a count of the transaction. So the number of transactions that each salesperson has had in each of the product areas. What I'd like to do though is instead of analyzing it by salesperson, what I'd like to do is have a look at the bands of units sold. So let's have a look at that. So I'm gonna remove Name from our pivot table, and all we need to do to do that is drag Name out and up into the field area again and it will remove it from our pivot table. Then I'm gonna go and add in the units into the rows.

Now, when I add units to rows, it's done what it normally does, and that is, for every single item in the column that I dragged in, it will have a new row entry for each element. So I've got minus 10, 9, 8, 7, 6, 5, 4, 3, 2, 1 and so on down my table. This isn't very useful for me. I can see the number of units, but what I'd really like to do is to band these into some kind of groupings so I get a bit more of a flavor about what's going on. So to do that, you right click in the column that you want to group, choose Group, and we'll get this little dialogue box appear. And it'll say, starting at and automatically pick the lowest figure in my group and ending at will automatically pick the highest figure in my group. Now, if I want this in bands of 10, for example, I might decide that actually I'm gonna have the ending range at a nice round 10 multiple, so that when we look at the groupings, it's clear what's what. So I'm gonna say, starting at -10 ending at 100, group in tens, click Okay. So now what we're looking at is a grouped banding of units and I can start to see how many items, how many transactions I've got for the different bands of units sold. So that's grouping.