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
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