Forum Discussion

AllyHoff11's avatar
AllyHoff11
Copper Contributor
Jul 01, 2024

Pivot Tables - Not Grouping By Month, Started July 1st

Hi! I pull about 100+ reports of data per week and I pivot all of them. When I pivoted new data today, and pull the date to column, it will not group at all (particularly I need it by month). Even when I go in to Settings > Group, nothing is there that allows me to group by month. I pull the same data every day, so there is no way there is any date that is a different value or format. The same data I pulled last Friday works and it groups by month. It looks like it's could be a new update problem. My coworkers are having the same issue. Anyone else?

excel
    • LBP10's avatar
      LBP10
      Copper Contributor
      Jul 02, 2024
      Same here. I have a suite of pivot table reports that I can no longer group by Month or Year. I tried rebuilding some of the pivot tables from scratch but got exactly the same issues. All started after the latest Microsoft update, July ‘24.

Resources