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?
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? Read More