Channel: WiseOwlTutorials

Category: Education

Tags: group valuesrow groupfree tutorialonline trainingpivot tablegroup numericfree trainingmicrosoftgroupingonline tutorialgroup numbersexcelvbagroup byvisual basic for applicationspivottutorialrowwise owlgroup

Description: By Andrew Gould Download files here wiseowl.co.uk/vba-macros/videos/vba-pivot-tables-charts/pivot-table-group-numbers 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: youtube.com/channel/UCbi5G5PjWBaQUFy7XU_O7yw/join Or you can click this link wiseowl.co.uk/donate?t=1 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 wiseowl.co.uk 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!