Sorting in a bar chart

[sagar_vij99]

Hi,

I have created a bar chart which is showing data by Teams. I also created a drill down group (team, year, month). I have used it in dimension and now when i click on any team it takes me to month -wise view but it is not sorted Jan-Dec but they are coming in order of their load(which i think).

can anyone please help me to solve this.?

Thanks

Sagar

[adamdavi3s]

Hi Sagar,

You need to change the sort on the sort tab, if you have month number do something like this in the sort expression for month name

=only({1}MonthNo)

[sdmech81]

Hi,

Please share the application.Hope your month order is not frm Jan -dec.

[sdmech81]

You need to order by your data inside the script based on date_Key

Then say in bar graph sort tab as sort by load order.

Hope this helps