Sort in pivot table

[LFM123]

Why is months not sorted correctly when Im making a pivot table from table?

[#2]

@LFM123 

Why is months not sorted correctly when Im making a pivot table from table?

Most probably because your table looks as below:

and your Excel Custom Lists don't have a list with January, February, ... December:

[#3]

@LFM123 

If creating the PivotTable add data to data model the rest shall be done automatically.