Wise Owl Answers How do I group a pivot table by a numeric field using VBA?

Опубликовано: 10 Февраль 2025
на канале: WiseOwlTutorials

3,123

By Andrew Gould

Download files here https://www.wiseowl.co.uk/vba-macros/...

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:
/ @wiseowltutorials

Or you can click this link https://www.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 https://www.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!