By Andrew Gould
Download files here [ Ссылка ]
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can join this channel to get access to perks:
[ Ссылка ]
Or you can click this link [ Ссылка ] to make a donation. Thanks for watching!
This video shows you how to apply grouping to a numeric row field in an Excel pivot table. You'll learn how to use the Group method, how to control the size of the buckets or bins and how to set the starting point of the groups. You'll also see several ways to refer to the range you need to apply the grouping to.
Chapters
00:00 The Question
00:24 Creating a Basic Pivot Table
01:12 Basic Grouping with a Numeric Field
02:28 Changing the Bucket or Bin Size
03:06 Changing the Start Value of the Groups
03:57 Referring to the Label Range
06:27 Changing the Pivot Table Position
07:17 Referring to the Row Range
Visit [ Ссылка ] for more online training resources in Microsoft Excel, Microsoft Power BI, DAX, VBA, Python, Visual C#, Microsoft SQL Server, SQL Server Reporting Services SSRS, SQL Server Integration Services SSIS, Microsoft Access and more!
![](https://s2.save4k.ru/pic/qrFs9kquG_0/maxresdefault.jpg)