Skip to Content
0
Former Member
Apr 29, 2009 at 09:53 AM

Sort one field base on another field

16 Views

Hi:

I think this maybe a simple question but I can't find the way to do that. For example in a bar chart, measure vs. month_name, where month_name is Jan., Feb., Mar., etc. By default, the bars are sort in alphabet order, but actually we usually want to sort by month_number like 1, 2, 3...

I know there is a "Custom Sort" option to adjust the order manually. However, it's unacceptable when dealing with multiple years. So how can I sort month_name base on month_number?

Thanks