-
Pivot Table Grouping
I just noticed, to my dismay, that the PivotTable dropdown on my Mac doesn't have any of the Grouping options I'm used to on my PC (year, quarter, etc.). Do the Group commands work in Mac's VBA?
eg.
[VBA]'Group Date by Month, Quarter, Year
pt.PivotFields("Date").LabelRange.Group Start:=True, End:=True, Periods:=Array(False, False, False, False, True, True, True)[/VBA]
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules