Weird DATE problem with pivot table [bug?]

[jonahsav]

Hi everyone,

ive been working on a sheet with some bank statement. i export these straight out of my bank, then i add some stuff and turn it into a pivot table. Extremely straight forward. But somehow once i put it into a pivot table and have the dates as my main Row's (first year, quarter and then month) it turns it into this.

Sorry its in Dutch, but as u can see, it recognises its 2023, then quarter 1, 2 and 3 go as it should go. then the first month of quarter 4 is also fine but then every date after 2-10-2023 is somehow a catagory of its own? not even inside 2023 while im 100% thats its written the same was as every other date. and its also all formatted as DATE.

what am i missing here?


thanks in advance

Jonah

 

[6StringJazzer]

Looks like you have stray ">" characters in the raw data. We can't tell much by looking at the pivot table. It would be more helpful to paste the raw data into a post.

 

[RoryA]

It looks like the date field was grouped before the latest data went in, so anything after the previous maximum date just gets put in a > category. You should be able to just re-group specifying a later max date.

 

[6StringJazzer]

I haven't seen that ">" before, I guess I never ran into that scenario.

 

[jonahsav]

It looks like the date field was grouped before the latest data went in, so anything after the previous maximum date just gets put in a > category. You should be able to just re-group specifying a later max date.

Thank you so much, i did indeed forget to do that