Change the month order in a chart from Jan - Dec to Aug - July

[rsimson1]

Hi,

Can someone please indicate a simple was of displaying the chart below starting with the the month of August to July instead of January to December?. Can this be done in the chart or must it be done in the script?

[sunny_talwar]

May be this as your sorting expression:

Match([Withdraw Month], 'Aug', 'Sep', 'Oct', 'Nov', 'Dec', 'Jan', 'Feb', 'Mar', 'Apr', 'May', 'Jun', 'Jul')

[swuehl]

You can do it in the chart, sort order by Expression

=Match(MonthField, 'Aug','Sep','Oct','Nov','Dec','Jan','Feb','Mar','Apr','May','Jun','Jul')

But if this is a general requirement, create your month field as dual with numeric value set accordingly. Then sort by numeric (Default) should just work fine.

[Kushal_Chawda]

go to chart properties -> Sort -> Expression -> put below condition

=match(YourMonthField,'Aug','Sep','Oct','Nov','Dec','Jan','Feb','Mar'.....'Jul')

[rsimson1]

Thanks Sunny this worked fine!

[rsimson1]

Thank you

[rsimson1]

Thanks for your help.

[MarcoWedel]

Another sorting  expression might be:

Mod([Withdraw Month]+4,12)

Regards

Marco

[Chanty4u]

or else

if u want entire qvw

u can set in

SET MonthNames= 'Aug', 'Sep', 'Oct', 'Nov', 'Dec', 'Jan', 'Feb', 'Mar', 'Apr', 'May', 'Jun', 'Jul';

[sunny_talwar]

In addition, I just remembered that I would add {1} so that the sorting doesn't change based on selections:

Match(Only({1} [Withdraw Month]), 'Aug', 'Sep', 'Oct', 'Nov', 'Dec', 'Jan', 'Feb', 'Mar', 'Apr', 'May', 'Jun', 'Jul')