User Profile

Basiliorio

Copper Contributor

Joined Oct 23, 2019

2 Posts

View All Badges

User Widgets

Recent Discussions

Re: Pivot Table grouping defaults to Month when I add data to data source
I chose the PowerPivot option and it appears to have worked. When I add or remove data to the source table, it does not change the grouping. It just adds the correct numbers grouped by Year. Thank you,
Oct 23, 2019 Place Excel
3.6KViews
0likes
0Comments
Pivot Table grouping defaults to Month when I add data to data source
I have a Pivot Table which is grouped by Year. When I add new records to data source, then hit refresh in Pivot Table, the grouping defaults to Month. I would like it to remain by Year. I tried the 'Disable automatic grouping of Date/Time columns in PivotTables' but that did not work. Any suggestions? Thank you,
Solved
Oct 23, 2019 Place Excel
PivotTable
3.7KViews
0likes
3Comments

Recent Blog Articles

No content to show