Sort Order In Cyclic Group

[Muthu]

Hi,

I am creating a chart with the cyclic group as dimension.

I have values like year month and week as the fields in the Cyclic Group,

I am selecting a filter in the calender range, august 2014 - March - 2015,

In the chart when I select the year its giving me correct values starting from August -2014,

as I have given condition in  the group sort order ( Year & num(Month,00)),

I Tried giving the same kind of sort order expression for week, But its not giving the correct values,

Please help.

Muthu

[jpenuliar]

attach your sample file to see your work and add what exactly is your required Sorting order

[sunny_talwar]

Can you try the load order for once:

It may be greyed out for some charts, but if its available can you give it a shot.

Best,

S

[rubenmarin]

Hi Muthu, If you have a date field related to each week, month..., in the settings for the group you can sort by expression using:

=Min({1}DateField)

This can be used for year, month, week...

[Or · Accepted solution]

You may want to try Weekname(myDate).

[awhitfield]

Hi Muthu,

see if the attached example helps

Andy

[Muthu]

Hi,

I tried giving load order,

It didn work.

[Muthu]

Hi,

Thank you all for your answers,

Instaead of week(Mydate) I have taken WeekName(MyDate)

It worked.