Issue with date format in pivot

[Judgedread]

Good Morning,

I'm facing an annoying issue, in my data sheet dates are formatted dd.mm.yyyy and when I create my pivot, data are read mm.dd.yyyy which makes the automatic grouping by month totally wrong.
I have checked my regional settings and everything is in dd.mm.yyyy.

Any idea where to change that ?

Thanks a lot !

 

[HolyExcel]

you could add a helpercolumn to your rawdata where you break down the date to days, months and years and then concatenate in other order. BTW: where did you check the language options? in windows?