Problem with month order in bar chart

[dcd123456]

Hello

I have a bar chart, i need to put the month of the year as dimension, in the data i have the date field and so i define a calculated dimension as year(H_MFECHA)&month(H_MFECHA).

The problem is that i have data from 03/2013 to 02/2014 and QV show in the bar chart 04/2013 as first month and 03/2013 as last month.

I attached an example.

thanks

regards

diego

[rustyfishbones]

Sort by Numeric Value maybe, not Y Value

[#3]

Create this variable in load statement

[dcd123456]

Perfect, with monthname(H_MFECHA) and sort by numeric Value the chart is correct

thanks

regards

diego

[sundarakumar]

Hi,

go to sort tab

check expression

write  "=num(H_MFECHA)"

uncheck ll other options.

it will sort correctly

Hope this helps.

-Sundar

[aveeeeeee7en]

See the Attachment.

Regards

Aviral Nag