Grouped data does not properly refresh? Or new data is combined into greater than column

[andycondor]

Hello,

I have pivot table, with with counts of events in a day, and I use grouping option to group by day. When I create it, it works great, until new day's arrive. All data for new day's are grouped into greater than group.

Example: If I created group on 20th, all data before 20th would display by single days, but not after 20th:

17th | 18th | 19th | 20th | >20th |

To work around it right now, I go group and ungroup each day to get new data into the range. Anyone has a solution?

Thanks!