Share via

Pivot Table Grouping

Anonymous
2016-04-05T17:43:15+00:00

I have a table that calculates the number of days that a case has been open and I'm trying to group the data into 30 day categories in my Pivot Table. (0-30, 31-60, etc.). My problem is that, even though the pivot table shows me the correct number of days, it won't let me group the data. I believe that it is because the data is derived from a formula, since I tried inputting it manually in a different table and it worked perfectly. Since I need to continue to track the days open, which will change every day, am I just not going to be able to get this to work? Thanks.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2016-04-05T19:01:58+00:00
    0 comments
  2. Ashish Mathur 100.8K Reputation points Volunteer Moderator
    2016-04-05T23:48:35+00:00

    Hi,

    How exactly are you grouping the number of days in intervals of 30?

    0 comments