Month sort problem last 12 months

[rolandg1881]

Hi!

I have the problem if i want see data from the last twelve months that the months are not in the correct "sequence".

it starts in june 2020 and ends in Mai 2020. You can see it in the attachment.

Any idea whats wrong? I tried any things but nothing worked correctly .

in the diagramm for the last 6 months i can see it correct with the same settings?

Thank you!

Roland

[NitinK7]

I think you missed file  attachment , please attach your qvf

[rolandg1881]

Ooops!

[NitinK7]

Create a field in script by using

Num(Month(DateField)) as MonthNum;

Sort tab:

Expression : MonthNum

or 

Expression: match(Month,'Jan','Feb','Mar' ...)

or

wildmatch(only({1}Month_field),'Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec') 

only({1})- with this it wont change the order.